i have 2 fact and 2 dimension tables in my universe . my
question is how get the data with two fact tables in a report?
Answer Posted / siddu
to create a derived table from two facts and you can use the derived table columns in report level
| Is This Answer Correct ? | 5 Yes | 6 No |
Post New Answer View All Answers
Difference between b.o 5.1 and 6.1b?
When to use local filter and when to use global filter?
how to prepare the documentation in business objects and where to get the requirement?
How to create a new calendar in CMC? Can u please tell me the process to create the required calendar. Ex:- Year of that calendar to start with Jan-15 and ends with Jan -30 and the Next month to start with Feb-31 and ends with Feb-14.
Give some information on report bursting?
Explain about alerts in bos, under what situation we need to use alerts?
In source system we have os - windows BO - 5.1.5. with webi 2.7.1 Repository database - oracle Reports database - Oracle and DB2 Nearly we have 1200 reports in present system , i want to move as it is to new hardware os- windows bo- 5.1.5 with webi2.7.1 repository - oracle reports - oracle and db2 let me know is there any migration techniques in same version. thanks in advance Usha
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
I have 2 doubts regarding the "Input Control" functionality in BI4: 1) Can the Input Controls in BI4 be manipulated? I mean, can we change the IC display as BOLD or change the values from Italics to regular? Or change the colors? 2) How to get hierarchy type control in IC? Let's say my first IC is for Country and second is for State. If I select a particulat country from Ist IC,second one should show me states belonging to selected country. Is that possible? Thanks in advance!!!
Please send me BO certification details and question papers? this is my mail id: valsreenivas@gmail.com
Explain difference between zabo and webi?
I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.
Can we configure two instances of CMS pointing to two different CMS system databases?
What is difference between custom hierarchy and report based hierarchy?
Can we create universe with no cache??