21. Explain what the Never Share property is?
Ans: Never share: this property is tagged to any of the sparse member such that it doesn’t share the data with its parent/children even though there is an explicit relationship exits but the data is just duplicated.
22. What is a PS command?
Ans: PS command can be used to find the number of processes running in UNIX environment.
23. How do find whether Essbase server is running or not on AIX UNIX?
Ans, ps –es! Grep
24. What is the difference between grep and egrep?
Ans: Grep: this statement is used to create or replace the file,Egrep: this statement is used to append the existing file.
25. How many members can be there under a dimension?
Ans: There is no limit.
26. What is a calculator cache and why is it used?
Ans: Calculator cache is the buffer zone in the memory which is used to track the data or create the data blocks at the time of calculation; calculator cache enables the centralized control of the memory in the calculator cache and also reduces the space and improves the performance of the cube. Essbase default is 20mb.
27. What is VBA?
Ans: VBA: Visual Basic Application Programming Interface (API) used for accessing the data in the cube using the spread sheet add-in.
28. What is an ad-hoc Report?
Ans: Report that is created on the fly.
29. List some report writer commands?
Ans: ANCESTORS: ANCESTORS ‘mbrname’ ASYM, ATTRIBUTE, {BLOCKHEADERS}
30. What are the different types of reports you can produce using report scripts?
Ans: Sym, asym.
31. In how many ways can you get a data out of Essbase cube?
Ans: Using Report script, with export command or function and Excel spread sheet add-in.
32. What does a Label only do? When you retrieve a Label Only tagged member in a report which has three children what value would you see?
Ans: It just carries the first child’s value… Label only tag will be used so that the data is not consolidated to the higher level or generation member or to the parent and we don’t see any value if we retrieve a label only tagged member.
33. Why do you use a load rule?
Ans: Load rule is used to create or update outline and/or load the data in the outline.
34. How do you clear a specific block in the cube?
Ans: CLEARBLOCK OR CLEARDATA with or without using FIX command. FIX (Actual)CLEARBLOCK NONINPUT; ENDFIX
35. What is the limit on the name of app and database?
Ans: App: 8 bites and database: 8 bites
36. How do you zoom only to the next level in the report?
Ans: we need to go to view menu and click on the zoom in to the next level
37. How do you calculate number of existing blocks?
Ans: The number of sparse dimensions member combinations having the data will give the number of existing blocks.
38. What is the optimized way to structure your outline?
Ans: Hour-glass method is best optimized way to structure the outline.
39. What is Generation and how would you compare it with level?
Ans: These two are build methods to develop the outline, generation is top-down method of building the outline and level build is the bottom-up method of building the outline.
40. What is a filter and why do you use them?
Ans: Filters are used for security purposes so that the users can only do what they are permitted to do with an application or a database.
Prev Next
0 comments:
Post a Comment