how many times can use the union operator in a report?
Answers were Sorted based on User's Feedback
Answer / v.sivakumar
The union Operator can be used seven times in the report
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / ramarkishna t
can you tell based on version i.e . in BOXI R2 and BOXI 3.0
The union Operator can be used seven times in the report
??
Is This Answer Correct ? | 1 Yes | 2 No |
Answer / shamanth
In XI 3.1 version there is no limitation...You can use any
no.of combined queries (Default option is UNION)
Is This Answer Correct ? | 0 Yes | 2 No |
what is prompt? Cascading prompt? Syntax
can we use detail in generation of reports? if customer id is a dimension in a report, what will happen if we define it as a detail?
what is static filter and dynamic filter
What is difference between merged dimension and forced dimension??
How to particiapte the columns availabe in the Derived tables in the Reporting window? How it's done?
what are the complex reports you have created. Tell me with example?
IF I WANT TO INSTALL BO ENTERPRISE PRODUCTS IN WINDOWS 2000 PROFESSIONAL SERVER ,WHAT SHOULD BE THE SYSTEM CONFIGURATION?
In banking domain how many Fact tables,Dimension table are present?
How the universe is working for fetching data? when it's get connected with db or data source? what is micro cube and when it is created? Is micro cube reside in inside of the universe?
If 2 tables are joined by Shortcut join, if query is generated based these join, what will be the join type and what will be the generated query? Thanks in advance?
CAN AUNIVERSE BE LINKED TO MORE THAN ONE DATASOURCE?
1. can we create report using multiple universes and how ? 2. how can we move the objects from universe A to universe B in report ? 3. how can we create aggregate table at universe level ? 4. if there is only one fact table in that universe, what happens if we get fan trap ?