oracle-hyperion

[vc_row full_width=”stretch_row” css=”.vc_custom_1559286923229{background-color: #f6f6f7 !important;}”][vc_column width=”1/2″][vc_tta_accordion color=”peacoc” active_section=”1″][vc_tta_section title=”What are the two storage options available in Essbase and what are the differences?” tab_id=”1559286383409-ab730398-6c03″][vc_column_text]ASO (Aggregate Storage Option) – Used for

  • If we have large number of dimensions (generally more than 10)
  • Most of the dimensions are sparse
  • We cannot write back in ASO. I heard recently that ASO will also have the write back capability.

BSO (Block Storage Option)-

  • Dimensions are less and dense (recommended values for no of dim are between 4 and 8).
  • We can write back hence much suited for planning applications.

Financial applications are generally dense structures and normal analytical cubes are sparse. Here we also need to understand what these dense and sparse members are. When the intersections or cells of two dimensions mostly contain a value it is dense. Say for example we have two dimensions period(Month or quarter) and region and we are calculation the sales amount. Generally maximum regions(countries, cities) will have some sales value for a particular month or quarter. Hence we can say that our period dimensions would be dense. But now instead of period, consider another dimension product. Now there are some products which are sold in only some particular regions hence for them there will be no values in other regions or will have very low percentage of data values hence the structure will become sparse.[/vc_column_text][/vc_tta_section][vc_tta_section title=”Can we build dimensions directly from data sources without using rule files.” tab_id=”1559286522681-3bf94e12-e7b7″][vc_column_text]No[/vc_column_text][/vc_tta_section][vc_tta_section title=”When do we generally use build rules files?” tab_id=”1561382593569-b1979b66-b066″][vc_column_text]To automate the process of creating dimensions with thousands of members.[/vc_column_text][/vc_tta_section][vc_tta_section title=”What are the three primary build methods for building dimensions?” tab_id=”1561382595833-dd54d407-26c0″][vc_column_text]1. Generation references
2. level references
3. Parent-Child references.[/vc_column_text][/vc_tta_section][vc_tta_section title=”In what case we can define generation 1 to a field in generation build method.” tab_id=”1561382597303-5168678c-55b9″][vc_column_text]We cannot define that as Generation 1 is not valid.[/vc_column_text][/vc_tta_section][vc_tta_section title=”Suppose we have assigned Generation 2 and Generation 4 as of now and think of adding generation 3 later some time. Can we build the dimension.” tab_id=”1561382598718-1fee5a6b-29dd”][vc_column_text]No. If gen 2 and gen 4 exists, we must assign gen 3.[/vc_column_text][/vc_tta_section][vc_tta_section title=”Can we create more than 2 dimensions using only one build rule file.” tab_id=”1561382602352-48d936eb-64df”][vc_column_text]Yes, we can do that but it is recommended to use separate rule file for each dimension.[/vc_column_text][/vc_tta_section][vc_tta_section title=”What is UDA( user defined attributes). How are they different than Aliases.” tab_id=”1561382603416-a2e0c7df-e6f8″][vc_column_text]UDA represents the class of the members. Aliases are just another names of the members. both are different and has different usage.[/vc_column_text][/vc_tta_section][vc_tta_section title=”Can we query a member for its UDA in a calculation script.” tab_id=”1561382604362-41fc1dd4-d143″][vc_column_text]Yes. You can query a member for its UDA in a calculation script.[/vc_column_text][/vc_tta_section][vc_tta_section title=”How does UDA’s impact database size?” tab_id=”1561382605426-bedbe54f-bb01″][vc_column_text]Absolutely no impact as UDA’s does not require additional storage space.[/vc_column_text][/vc_tta_section][vc_tta_section title=”What is the difference between UDA’s and Attribute dimensions?” tab_id=”1561382606689-6de5471f-2224″][vc_column_text]Attribute dimensions provides more flexibility than UDA’s. Attribute calculations dimensions which include five members with the default names sum, count, min, max and avg are automatically created for the attribute dimensions and are calculated dynamically.[/vc_column_text][/vc_tta_section][vc_tta_section title=” How does Attribute dimensions and UDA’s impact batch calculation performance?” tab_id=”1561382593038-8e7f1218-a7ac”][vc_column_text]1. UDA’s- No Impact as they do not perform any inherent calculations.
2. Attribute dim- No Impact as they perform only dynamic calculations.[/vc_column_text][/vc_tta_section][vc_tta_section title=”How can we display UDA’s in reports? How do they impact report report performance.” tab_id=”1561382592598-bfa5a635-55f4″][vc_column_text]UDA’s values are never displayed in the reports and hence do not impact report performance.[/vc_column_text][/vc_tta_section][vc_tta_section title=”How does Attribute dim impact report performance?” tab_id=”1561382592102-02f6742f-af9d”][vc_column_text]They highly impact the report performance as the attributes are calculated dynamically when referenced in the report. For very large number of att dim displayed in the report, the performance could drastically reduce.[/vc_column_text][/vc_tta_section][vc_tta_section title=”While loading the data, you have applied both the selection criteria as well as rejection criteria to a same record. What will be the outcome.” tab_id=”1561382591605-a59a34b3-da74″][vc_column_text]The record will be rejected.[/vc_column_text][/vc_tta_section][vc_tta_section title=”How is data stored in the Essbase database?” tab_id=”1561382591221-5a07bad8-cf1f”][vc_column_text]Essbase is an file based database where the data is stored in PAG files of 2 GB each and grows sequentially.[/vc_column_text][/vc_tta_section][vc_tta_section title=”Can we have multiple databases in one single application?” tab_id=”1561382590677-cc47cbcf-ee26″][vc_column_text]Yes. But only one database per application is recommended.[/vc_column_text][/vc_tta_section][vc_tta_section title=”Can we have one ASO database and one BSO database in one single application. If yes, how and If No, why.” tab_id=”1561382590095-0dd9d5a4-e5bf”][vc_column_text]No. Because we define ASO or BSO option while creating the application and not database. Hence if the application is ASO, the databases it contains will be that type only.[/vc_column_text][/vc_tta_section][vc_tta_section title=”What is the role of provider services.” tab_id=”1561382589718-2e1a6ceb-a239″][vc_column_text]To communicate between Essbase and Microsoft office tools.[/vc_column_text][/vc_tta_section][vc_tta_section title=”What is an alternative to create meta outline, rule file and load data.” tab_id=”1561382589333-47659694-5e1f”][vc_column_text]Integration services and in version 11, we have Essbase studio.[/vc_column_text][/vc_tta_section][vc_tta_section title=”Can we start and stop an application individually. How can this be used to increase performance.” tab_id=”1561382588926-dd3c13fa-09be”][vc_column_text]Yes. We can manage our server resources by starting only the applications which receive heavy user traffic. When an application is started, all associated databases are brought to the memory.[/vc_column_text][/vc_tta_section][vc_tta_section title=”We have created an application as unicode mode. Can we change it later to non-unicode mode.” tab_id=”1561382588517-7fc83786-ee5a”][vc_column_text]No.[/vc_column_text][/vc_tta_section][vc_tta_section title=”A customer wants to run two instances of an Essbase server on a same machine to have both test env and Development env on the same server. Can he do that?” tab_id=”1561382588060-9c018b10-4231″][vc_column_text]Yes. We can have multiple instances of an Essbase server on a single machine and there will be different sets of windows services for all these instances.[/vc_column_text][/vc_tta_section][vc_tta_section title=”suppose I have a dimension A with members B and C and I do not want B and C to roll up to A. how can I do this.” tab_id=”1561382587557-eee3186e-5475″][vc_column_text]Using (~) exclude from consolidation operator.[/vc_column_text][/vc_tta_section][vc_tta_section title=”What does never consolidate operator (^) do?” tab_id=”1561382583069-d03ea374-27b7″][vc_column_text]It prevents members from being consolidate across any dimension.[/vc_column_text][/vc_tta_section][/vc_tta_accordion][/vc_column][vc_column width=”1/2″][vc_tta_accordion color=”peacoc” active_section=”1″][vc_tta_section title=”Can we have multiple meta outlines based on one OLAP model in Integration services?” tab_id=”1561382561432-7f73ef2a-cc67″][vc_column_text]Yes[/vc_column_text][/vc_tta_section][vc_tta_section title=”Can we have an meta outline based on two different OLAP models.” tab_id=”1561382561455-654071d3-eb53″][vc_column_text]No.[/vc_column_text][/vc_tta_section][vc_tta_section title=”What is hybrid analysis?” tab_id=”1561382611424-56181e07-6453″][vc_column_text]Lower level members and associated data remains in relational database where as upper level members and associated data resides in Essbase database.[/vc_column_text][/vc_tta_section][vc_tta_section title=”Why top-down calculation less efficient than a bottom-up calculation? Being less efficient, why do we use them.” tab_id=”1561382613753-7c9c9136-4ca1″][vc_column_text]In the process it calculates more blocks than is necessary. Sometimes it is necessary to perform top-down calculation to get the correct calculation results.[/vc_column_text][/vc_tta_section][vc_tta_section title=”On what basis you will decide to invoke a serial or parallel calculation method.” tab_id=”1561382614729-6b63842b-62b1″][vc_column_text]If we have a single processor, we will use serial calculation but if we have multiple processors we can break the task into threads and make them run on different processors.[/vc_column_text][/vc_tta_section][vc_tta_section title=”What is block locking system?” tab_id=”1561382615672-42dd66a8-6425″][vc_column_text]Analytic services (or Essbase Services) locks the block and all other blocks which contain the Childs of that block while calculating this block is block locking system.[/vc_column_text][/vc_tta_section][vc_tta_section title=” Dynamic calc decreases the retrieval time and increases batch database calculation time. How true is the statement?” tab_id=”1561382616984-e392adb7-34cd”][vc_column_text]The statement should be just opposite. As dynamic calc members are calculated when requested, the retrieval time should increase.[/vc_column_text][/vc_tta_section][vc_tta_section title=”Questions” tab_id=”1561382618152-4fb6fc3a-9883″][vc_column_text]Answer[/vc_column_text][/vc_tta_section][vc_tta_section title=”Can we have multiple meta outlines based on one OLAP model in Integration services?” tab_id=”1561382619930-3767e1f0-f3d6″][vc_column_text]Yes[/vc_column_text][/vc_tta_section][vc_tta_section title=”What are LRO’s( Linked Reporting Objects)?” tab_id=”1561382620762-261798c4-b2da”][vc_column_text]They are specific objects like files, cell notes or URL’s associated with specific data cells of Essbase database. You can link multiple objects to a single data cell. These linked objects are stored in the server. These LRO’s can be exported or imported with the database for backup and migration activities.[/vc_column_text][/vc_tta_section][vc_tta_section title=”How does UDA’s impact database size?” tab_id=”1561382621738-44e10b8a-ca7d”][vc_column_text]There will be no impact on the database as the UDA’s doesn’t store data in the database.[/vc_column_text][/vc_tta_section][vc_tta_section title=” Can we create UDA’s and apply it to Dense as well as Sparse dimensions?” tab_id=”1561382622978-99f18b2d-fe4d”][vc_column_text]Yes[/vc_column_text][/vc_tta_section][vc_tta_section title=”Types of Partitions available in Essbase?” tab_id=”1561382623945-e109c4d3-ece0″][vc_column_text]Three types of partitions are there.
1. Transparent partition: A form of shared partition that provides the ability to access and manipulate remote data transparently as though it is part of your local database. The remote data is retrieved from the data source each time you request it. Any updates made to the data are written back to the data source and become immediately accessible to both local data target users and transparent data source users
2. Replicated Partition:
3. Linked Partition:[/vc_column_text][/vc_tta_section][vc_tta_section title=”Why top-down calculation less efficient than a bottom-up calculation? Being less efficient, why do we use them.” tab_id=”1561382625642-843354b1-1f56″][vc_column_text]In the process it calculates more blocks than is necessary. Sometimes it is necessary to perform top-down calculation to get the correct calculation results.[/vc_column_text][/vc_tta_section][vc_tta_section title=”On what basis you will decide to invoke a serial or parallel calculation method.” tab_id=”1561382626563-0fa3f678-a5bf”][vc_column_text]If we have a single processor, we will use serial calculation but if we have multiple processors we can break the task into threads and make them run on different processors.[/vc_column_text][/vc_tta_section][vc_tta_section title=”How can you display UDA’s in reports?” tab_id=”1561382627658-bb4ddb6b-277e”][vc_column_text]UDA’s values are never displayed in the reports and hence do not impact report performance.[/vc_column_text][/vc_tta_section][vc_tta_section title=” What are the specified roles other than Administrator to view sessions, disconnect sessions or kill users requests for a particular application?” tab_id=”1561382628592-dd61fe2e-19d3″][vc_column_text]You should have the role of Application manager for the specified application.[/vc_column_text][/vc_tta_section][vc_tta_section title=”What is block locking system?” tab_id=”1561382630393-e350687e-823e”][vc_column_text]Analytic services (or Essbase Services) locks the block and all other blocks which contain the Childs of that block while calculating this block is block locking system.[/vc_column_text][/vc_tta_section][vc_tta_section title=”What are the three options specified in Username and Password management under security tab in Essbase server properties.” tab_id=”1561382632977-3b296953-06eb”][vc_column_text]1. Login attempts allowed before username is disabled.
2. Number of inactive days before username is disabled.
3. Number of days before user must change password.[/vc_column_text][/vc_tta_section][vc_tta_section title=”Can we have multiple databases in one single application?” tab_id=”1561382634764-ad5070ba-db90″][vc_column_text]Yes. But only one database per application is recommended.
Depend on which database that you are going to create. For Example: If you are creating ASO then we can’t create more that 1 db per application. If you are creating BSO then you can create more than 1 db per application[/vc_column_text][/vc_tta_section][vc_tta_section title=”How is data stored in the Essbase database?” tab_id=”1561382636355-5dfe038c-83df”][vc_column_text]Essbase is an file based database where the data is stored in PAG files of 2 GB each and grows sequentially.[/vc_column_text][/vc_tta_section][vc_tta_section title=”We have created an application as unicode mode. Can we change it later to non-unicode mode.” tab_id=”1561382638762-3bfa136c-84a1″][vc_column_text]No[/vc_column_text][/vc_tta_section][vc_tta_section title=”Dynamic calc decreases the retrieval time and increases batch database calculation time. How true is the statement?” tab_id=”1561382649403-b75ce50f-0f5c”][vc_column_text]The statement should be just opposite. As dynamic calc members are calculated when requested, the retrieval time should increase.[/vc_column_text][/vc_tta_section][vc_tta_section title=”What is the role of provider services.” tab_id=”1561382651188-733a0ad7-4f7c”][vc_column_text]To communicate between Essbase and Microsoft office tools.[/vc_column_text][/vc_tta_section][vc_tta_section title=”A customer wants to run two instances of an Essbase server on a same machine to have both test environment and Development environment on the same server. Can he do that?” tab_id=”1561382674843-1f0b68aa-358c”][vc_column_text]Yes. We can have multiple instances of an Essbase server on a single machine and there will be different sets of windows services for all these instances.[/vc_column_text][/vc_tta_section][/vc_tta_accordion][/vc_column][/vc_row][vc_row full_width=”stretch_row” overlay_color=”rgba(12,12,12,0.58)” css=”.vc_custom_1528340415800{padding-bottom: 104px !important;background-image: url(https://wordpresslms.thimpress.com/wp-content/uploads/sites/4/2017/06/layer-532.jpg?id=231) !important;background-position: center !important;background-repeat: no-repeat !important;background-size: cover !important;}” el_class=”overflow-visible become-teacher”][vc_column width=”1/2″][vc_column_text el_class=”align-right”]

Please login to send your request!
[/vc_column_text][/vc_column][vc_column width=”1/2″ el_class=”talk”][vc_column_text el_class=”thim-content-talk”]I’m a Copywriter in a Digital Agency, I was searching for courses that’ll help me broaden my skill set. Before signing up for Rob’s.[/vc_column_text][/vc_column][/vc_row]

WhatsApp us