We want to restrict top 26 rows ... in report
is there any rownum object from which we can do this?
Submitted by: AdministratorRestrict Top 26 Rows: Depends on how you want to do it.
In a report: Drag the Dimention and measures into report. Click on the Dimention object and use the RANK button on the tool bar. you can specify the the Top 26 or Bottom(Depending on the requirement) values of a measure. It also provides some calculation like Sum/Percentage
If you want to restrict the Top 26 in the query itself, you might have to create an object in the universe. May have to use the analytical functions based on which you need to Rank the Data.
Submitted by: Administrator
In a report: Drag the Dimention and measures into report. Click on the Dimention object and use the RANK button on the tool bar. you can specify the the Top 26 or Bottom(Depending on the requirement) values of a measure. It also provides some calculation like Sum/Percentage
If you want to restrict the Top 26 in the query itself, you might have to create an object in the universe. May have to use the analytical functions based on which you need to Rank the Data.
Submitted by: Administrator
Read Online BO Designer Job Interview Questions And Answers
Top BO Designer Questions
☺ | What is index awareness in universe? |
☺ | Could any one explain me how to create cascading prompts? |
☺ | What are steps we have to follow in designing the userfriendly Universe? |
☺ | How do we design a universe? |
☺ | How to create Universe using Flat file in BO6.0? |
Top Data Warehouse Job Categories
☺ | Warehouse Assistant Interview Questions. |
☺ | Ab Initio Interview Questions. |
☺ | Data Stage Interview Questions. |
☺ | ColdFusion Interview Questions. |
☺ | Data Warehouse Supervisor Interview Questions. |