HI i have a table with 4 columns in back end like sales id,
sales revenue, order id and order amt. Now i have created 2
prompts at query level 1st on sales id and 2nd on order id.
Now if i run the report for 1st prompt it has to display
sales id and sales revenue. Then if i run the report for 2nd
prompt then it has to overwrite the table with Order ID and
order amount. How you will handle this?
Answer Posted / gowthami
Sub Query 1:
Result objects: sales id, sales revenue
Filter: sales id – prompt
Union
Sub Query 2:
Result objects: order id, order amount
Filter: order id – prompt
Now union logic will be applied at query. If you select value for order id it will display the data related to that id, if you select sales id in the filter then sales data will be displayed. Common filters will be displayed to select the data
Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
What is top business?
Hi, I would like to know how is the integration if we want to use Oracle Essbase as the Cube Engine, and present the Cube by Business Objects Presentation Layer? Can Oracle Essbase be integrated with Business Objects? Thanks,
How to open a universe with out using the Designer ??
What is the difference in creating filters in designer and business objects?
Difference between b.o 5.1 and 6.1b?
What three things do you consider to be the most important factors for a manager?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
what is universe null
Can I create a master report in webi having 15 dimensions and 150 kpi's with 100GB of data and store it in cache ,So that I can use Cache for building new reports with less dimensions and Kpi's without hitting database againg just using cache??Please suggest...
How to Explain about BO projects in interviews?(in Banking,insurance,Manufacturing domains)
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Then how to select the source by using webi or deski reports into crystal reports? i think main source is Businessview. where u import the datasource ?
Explain about an assignment you worked on in which you had to amass a huge amount of data, and then analyze it?
How to create Index to the table in the universe designer and how it improves the Query performence