Skip to main content

Top 170 Hyperion Essbase Interview Questions



My Friend Mr.Koti has attended interview for Hyperion Essbase in HCL,Accenture,TCS,CSS,CTS etc. The following list of questions he prepared during his Hyperion Essbase interview.



1 Talk about committed and uncommitted access?Committed:







2 What is CCONV?







3 What is an Outline?







4 Can you define different types of partitions between the same two databases?







5 What is Sparse restructure?







6 Give a few examples of LRO's?







7 What is "Enterprise Analytics"?







8 What are the reasons to turn off CCTRACK?







9 What is CCTRACK?







10 Can you change the member combination associated with any linked object?







11 What is Dynamic calculator cache?







12 How do you order the Outline?







13 What is Essbase OLAP server?







14 How does a user can view data?







15 When Essbase restructures both the data blocks and the index, it uses the files described







16 What is UDA( user defined attributes). How are they different than Aliases.







17 Do shared members share LRO's?







18 How do you create ASO in the Automated Way?







19 What are the actions that improve performance for restructuring?







20 When do you use RLE over Bitmap Compression?







21 What is the use of multidimensional database such as Essbase?







22 What is the process to build a currency conversion application and perform conversions?







23 How do you create an ASO application?







24 Essbase kernel file that contains control information used for db recoverydbname.tct







25 What happens if you make all dimensions sparse?







26 Explain in detail about the features of ASO?







27 How can you turn off CCTRACK?







28 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?







29 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?







30 Can a single database serve as the data source or data target for multiple partitions?







31 How do you create LRO's?







32 Is overlapping partition valid in all the partitions?







33 What is the use of variance reporting?







34 do not haveindexes or data blocks.







35 What is the highest level of consolidation in the outline?







36 How does Attribute dimensions and UDA's impact batch calculation performance?







37 How can I migrate an application from my test environment to the production environment. Can I still do this if my test environment is a windows one and my production env is UNIX one. Also can I still do it if my test env and prod env versions are different.







38 When do you disable compression?







39 What is an Index entry?







40 What are the conversion methods supported by Essbase for currency applications?







41 Can we query a member for its UDA in a calculation script.







42 When does a DB restructure?







43 What is data compression?







44 What is a shared member?







45 What are the members for which Two-pass calculations can be given?







46 Can you load data or calculate data on client machine?







47 What is an alternative to create metaoutline, rule file and load data.







48 What is Data cache?







49 What are benefits of partitioning?







50 What is a Linked Reporting Object (LRO)?







51 Types of Partitions available in Essbase?







52 What is annotating database?







53 What are the three dimension that should be present in main database of currencyapplication?







54 What is the maximum number of values in the database?







55 What is transaction control file?







56 When do we generally use build rules files?







57 What happens if you make all dimensions dense?







58 What are the design considerations for calculation optimization?







59 A customer has a cube with 13 dimensions and the performance was fine. Now they have added two more dimensions in the existing cube and the performance becomes very very slow. Customer said logically nothing wrong with the two new dimensions they have added. What could be the reason for slowdown.







60 What are the memory caches used by Essbase to coordinate memory usage?







61 What are Database Objects?







62 What are Standard dimensions?







63 do not have two pass logic and built in time balancefunctionality.







64 ASO formulas are written in MDXsyntax.







65 What are “.sel” files?







66 What is the Design Process?







67 What is Outline-only restructure?







68 You canload data to level zero members only.







69 What are the dimensions that should be present in currency database of currencyapplication?







70 do not use calculation scripts







71 What is the process for designing a partitioned database?







72 Type of partition:







73 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.







74 Database SizeFragmentation QuotientThreshold







75 Explain the process of sparse restructure?







76 Which restructure operations are faster?







77 Can we convert the converted currency back into its local currency?







78 How can you display UDA’s in reports?







79 What is Fragmentation?







80 ASO is read-only







81 What is a calculation script?







82 What does the consolidation properties do?







83 What is a Hybrid Analysis?







84 What are substitution variables?







85 What are the memory caches used by Essbase to coordinate memoryusage?







86 What are the different types of data sources?







87 What is a dynamic Calc?







88 Explain the process of dense restructure?







89 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.







90 What is Index cache?







91 What are the ways to improve performance during data loads?







92 What are the two storage options available in Essbase and what are the differences?







93 Can we create UDA’s and apply it to Dense as well as Sparse dimensions?







94 What are the major difference between ASO & BSO?







95 When do you give an accounts tag to a dimension?







96 What is the significance of time balance properties?







97 When you convert currencies using the CCONV command, are the resulting data blocksare marked as dirty or clean?







98 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.







99 What is commited access?







100 What dimension can be given time balance properties?







101 What are the two types of internal structures in Essbase?







102 What does never consolidate operator(^) do?







103 Why do we need to have classification as dense and sparse dimensions?







104 In what case we can define generation 1 to a feild in generation build method.







105 How do you create an ASO database using ASO Outline Conversion Wizard ?







106 What are important points while building an outline?







107 What is Essbase Partitioning?







108 new kind of storage mechanism







109 What are the advantages and disadvantages of using committed access?







110 What is the difference between UDA's and Attribute dimensions?







111 How can you create a database?







112 Does adding or removing links to a cell does not affect the cell contents?







113 Uncommitted:







114 What is Dense restructure?







115 Can we create more than 2 dimensions using only one build rule file.







116 Can we have one ASO database and one BSO database in one single application. If yes, how and If No, why.







117 What is Metadata?







118 Can we start and stop an application individually. How ca this be used to increase performance.







119 Can we have multiple metaoutlines based on one OLAP model in Integration services?







120 What are LRO's( Linked Reporting Objects)?







121 Can you add time members that are not tagged as time?







122 What are the advantages of Dynamic calc?







123 What are the parts of partition?







124 Why do we need to limit the LRO file sizes for storage conversion?







125 How does Attribute dim impact report performance?







126 What is a Data block?







127 What is overlapping partition?







128 What is a cell/data value?







129 Can we partition an attribute dimension?No







130 What are the restructuring options in saving database?







131 What are administrative requests and client requests?







132 What is the limitation on version and mode during partition?







133 What is a transaction?







134 What are the Essbase Application tools?







135 What is LRO (Linked reporting objects)?







136 What are types of data compression?







137 What are the three options specified in Username and Password management under security tab in Essbase server proprties.







138 What are the file extensions for an outline, rule file and a calc script.







139 What is the structure of currency applications?







140 How do you rename members?







141 Is there any limitation on number of members?







142 What are data locks?







143 How does Essbase locate and retrieve linked objects?







144 Can we build dimensions directly from data sources without using rule files.







145 What are the types of Partitions available in Essbase?







146 What are the specified roles other than Aministrator to view sessions, disconnect sessions or kill users requests for a particular application?







147 As your business changes, you change the Essbase database outline to capture new product lines, provide information on new scenarios, reflect new time periods, etc. Some changes to a database outline affect the data storage arrangement, forcing Essbase to restructure the database.







148 What is a location alias?







149 How do you set dense and sparse settings?







150 How do you differentiate ASO applications?







151 How can we display UDA's in reports? How do they impact report report performance.







152 When do you use label only?







153 What is a rule file?







154 When do you use substitution variables in partitions?







155 What is Calculator cache?







156 What are different types of dimension tags?







157 How does Essbase calculate the data?







158 What are the conditions affecting Database restructuring?







159 Can we use attribute values to partition a database?Yes







160 Stop OrderPlanning ServiceRMI registryAASStart OrderAASRMI registryPlanning ServiceScreen shots of services shown below:







161 What is a formula?







162 What is Data file cache?







163 What are the ways to improve performance during data loads?







164 What is Implicit Restructures?







165 What is Explicit Restructures?







166 Which transaction is always in committed mode?







167 What is isolation level and what are the types of isolation levels?







168 What are “.EQD” files?







169 What is a Two-Pass calculation?







170 no concept as denseand sparse dimensions.

Comments

  1. PLEASE PROVIDE ANSWERS AS WELL

    ReplyDelete
  2. Nice Post. The Hyperion Panning tutorial was Really help ful for me. Keep Sharing…………

    ReplyDelete
  3. Nice Post. The Hyperion Panning QA'S was Really help ful for me. Keep Sharing…………

    ReplyDelete

Post a Comment

Popular posts from this blog

Contact Me

Do You have any queries ?                   If you are having any query or wishing to get any type of help related Datawarehouse, OBIEE, OBIA, OAC then please e-email on below. I will reply to your email within 24 hrs. If I didn’t reply to you within 24 Hrs., Please be patience, I must be busy in some work. kashif7222@gmail.com

Top 130 SQL Interview Questions And Answers

1. Display the dept information from department table.   Select   *   from   dept; 2. Display the details of all employees   Select * from emp; 3. Display the name and job for all employees    Select ename ,job from emp; 4. Display name and salary for all employees.   Select ename   , sal   from emp;   5. Display employee number and total salary   for each employee. Select empno, sal+comm from emp; 6. Display employee name and annual salary for all employees.   Select empno,empname,12*sal+nvl(comm,0) annualsal from emp; 7. Display the names of all employees who are working in department number 10   Select ename from emp where deptno=10; 8. Display the names of all employees working as   clerks and drawing a salary more than 3000   Select ename from emp where job=’clerk’and sal>3000; 9. Display employee number and names for employees who earn commission   Select empno,ename from emp where comm is not null and comm>0. 10

Informatica sample project

Informatica sample project - 1 CareFirst – Blue Cross Blue Shield, Maryland (April 2009 – Current) Senior ETL Developer/Lead Model Office DWH Implementation (April 2009 – Current) CareFirst Blue Cross Blue Shield is one of the leading health care insurance provided in Atlantic region of United States covering Maryland, Delaware and Washington DC. Model Office project was built to create data warehouse for multiple subject areas including Members, Claims, and Revenue etc. The project was to provide data into EDM and to third party vendor (Verisk) to develop cubes based on data provided into EDM. I was responsible for analyzing source systems data, designing and developing ETL mappings. I was also responsible for coordinating testing with analysts and users. Responsibilities: ·          Interacted with Data Modelers and Business Analysts to understand the requirements and the impact of the ETL on the business. ·          Understood the requirement and develope