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
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Explain in detail about type 2(scd),
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
What sort of existing documents should business analysts refer to when starting on a new project?
What is the difference between datawarehousing and businessintelligence?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
is it possible to export the webi reports to crystal reports?with out using businessview?
Differences between business objects and web intelligence reports?
Explain when to use local filter and when to use global filter?
any difficulitis have you phase while creating bo reports and how did u solve it
Explain are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
U r project in which stage in implementation?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
Can we Save (save as) WEBI Doc as DESKI?
what is xcelsius architecture?