Latest Answer : Very simple, click scope of analysis-> select by hierarcy radio button -> check boxes of year and month -> click ok ->run->generate report-> click drill tab ->you will get another report with drill symbol on it -> open it-> ...
How to break a Date field into Year, month, week,day?(For example: I have a field INVOICE_DATE. Now i want to break it as Year, month..... i.e. in time dimension.) DO i need to have some changes in Universe?
How do you Find the average of an object with out using the Average Function and by using only sum,average,max,min?
1. What is an Universe? 2. How many Universes did you create? 3. Tell me how many classes where there, and objects in each class? 4. What is Object qualification? 5. Tell me about a complicated object you have created? 6. What was the size of the database? Which server? 7. How many user were there? 8. What problems you have faced while creating an universe? tell me an incident and how you went about solving it? 9. Were any experts called from BO while you were on the project? 10. What was the Database?
What is info bust in BO, What is the main purpose of this?What is meant by report tracing in BO?When and where we use @variable function in BO?
Latest Answer : #CONTEXT Error ...
Scnario: Let you have a reporting period one object in a prompt, and one measure say 'Limit amt' another object you want to show in a report. Now once user enters the prompt, you want reporting period data prior to the entered value in the report along with which is entered in prompt.That means say reporting period is 2007, but you should show 2006 data also in the report. How do you implement it?
If I needed to restrict a report to show the 50 most used contractors How would I select the top 50?
I am trying to create S.No. column for a report by writing this formulae =RowIndex() Where (="2002")But is generating S.No starting from 0 (not from 1).
Latest Answer : Create a new variable in report.=RunningCount( Body ; Row ). ...
