If there are no indices defined on any of the columns in the above two tables, which columns would you index to speed up the left join query?
i am getting multiple values from prompt like (Value1;Value2;Value3;Value4). how can i place space between values like (Value1; Value2; Value3; Value4)
when will use compatible and incompatible objects?
1 Answers Business Intelligence Analytics, iGate, TCS,
what r the advantages of creating the universe?
What is the error that occurs while detecting the cardinalities in the universe pane if we create a join between the normal table and the aggregate table...
how to do Ad-hoc reporting ?
How to create predefined filters in B.O.
what is the syntax for aggregate awareness?
3 Answers Exilant, i-Tree, Wipro,
I have two data providers with common dimension and measures. The only difference between two data providers is in condition 'Fiscal Year'.One data provider calculates for current year and other one calculates for previous year. So in prompts if I am passing 2008 as current year then the two data providers should be able to calculate for current year and previous year individually. So Can anybody tell me how to do calculation in data providers. ( I am using BO WebI report )
What is maximum number of promts we can give in a BO report?
How to make alternative rows red and green in WebI Report?
1. how do u connect one report with another ? 2. how do u generate reports from different data sources( ex: oracle, sql server)? 3.how do u give the security to universe ?
What are the traps ? What are the disadvantages of traps?