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 / pradeep
Create a Short cut join between the two fact tables in the
universe.
| Is This Answer Correct ? | 2 Yes | 8 No |
Post New Answer View All Answers
what is the difference b/w the refresh and buffered data?
hi all of u, i want to learn the course in SAP(BI).because of there is no calls for BO. And the another region is it will be converted into SAP module. is it OK for me? is there any feauture in coming days? could any one plz send me the message
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?
What is the dense rank?
1)I have createcd a dashboard on Bex query. How to refresh the Dashboard without hitting the bex query? 2)What is Event based scheduling in BO? 3) How to display the BO webi report title using a function? 4) For eg in my webi report iam having a person name like Jhon Peter Adam. But i need to get only the middle name of the person like Peter. What function is used in Webi to get this?
What is difference between webi and infoview?
Explain what is aggregate table and aggregate fact table ... Any examples of both?
Explain which versions are used in the bo dashboard work?
Explain how to schedule the report in b.o?
Explain is there any tool that can compare two unvs / two rpts , built using bo 5.1 / bo 6.5?
Can anybody tell me what are the tuning problems?
can some body explain how migrate the BoXI r2 to BO 3.x and crystal reports XI r1 to Crystal report 2008 ?
i want my connection to be dynamic. How can I make it. I mean the username and password should be dynamic. How?
Regarding Hyperlinking in Business Objects. We have a few reports in QA environment where a number of hyperlinks are employed using OpenDoc function.In some of the reports,hyperlink is used to move to another tab within the same report.The formula used include "DocID" and ReportName="tab name".This works fine but now,for the PROD move,this will not work as the Doc Ids are subject to change. Is there a way to overcome this?Without DocID,how will move to a particular tab? Thanks in advance
How to generate the report from excel sheet?