I want to do on drill calculation?
Actually My report is like
Continent Amount(Global Currency in dollar)
ASIA 200
UK 100
On Drill ASIA
Country Amount
INDIA 5712(120*47.6)
SINGAPORE 128(80 * 1.6)
On Drill INDIA
State Amount
DELHI 3712
CHENNAI 2000
Answer Posted / gowthami
U have the below objects
Continent, Country, State and amount
Make sure the objects are in above hierarchy in universe under the class
Result objects: Continent and amount
Set scope of analysis as level 3
Create a tabular report with continent and amount.
You will be able to do drill operations
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is Indexing? how did u implement indexing?
What is aggregate table and aggregate fact table ... Any examples of both?
any difficulitis have you phase while creating bo reports and how did u solve it
Explain what is the difference between business requirement document and use case document.
If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
Can anybody tell me what are the tuning problems?
How we drill up week to month?
How to schedule the report in b.o?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
Let me know the things we can do in webi and cannot do it in full client and vice verse for bo6.5?
Explain in detail about type 1?
What task is 98% of the required work of a business analyst?
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
CAN ANY BODY PROVIDE DESCRIPTION OF ONE COMPLEX UNIVERSE AND ONE COMPLEX REPORT IN BOS 6.5 TO SRINIVASBO@YAHOO.CO.IN
What Is Snow Flake Schema?