if we shortcut join between two tables what will be the output?that it will give all columns or same columns?
2 5457I have 2 tables. Table 1 is employee table and Table2 is department table. In employee table i have 1,2,3,4,5 emp id's,in Dept table i have various dept's like a,b,c and i have 2,3,4 emp id's in my dept table.I joined with these 2 tables.I want the results for equi join means how many records will fetch.In the same scenario i have to know the left outer join, right out join and full outer join resuls means how many records will come. can any body tell me the answers
IBM,
1 5428What is Custom Sorting? In development environment we had applied custom Order on Month which is having the following list of values September,October,March,August and December only.But in Production environment Month is having all LiSt of Values like 12 MOnths(Jan to Dec).So ,How it will effect the Sorting in production environmentof universe and as well as in reporting????? Thanks in advance.
3 8129What is the differrence between prompt & @prompt? What is the differrence between Xcelsius & Web-I Report?
3 5333Hi, i have 10 data providers in report? i want to see only two data providers remaining are hide? how can do it? Thanks&Regards raghu.shiva
1 4935How to combine(union) TWO Stored procedures data in a report. It means report has two data providers and one report tab.
IBM,
1 3568Post New Business Objects Questions
(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.
Is there any other repository domains rather than universe, security, document?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
What we need to discuss with designer before starting the universe designing.
What is the difference in creating filters in designer and business objects?
What are the general problems that are faced while importing the .biar files and what is the solution to overcome it in business objects?
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?
how to prepare the documentation in business objects and where to get the requirement?
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...
What would you consider as your biggest achievement and why?
how to create reports on screech?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
Can we create universe with no cache??
Can anybody tell me what are the tuning problems?