Is it necessary to give joins to the aggrigate tables in
the universe?
- 2 Answers
- 4278 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / gowthami
It is necessary to join the aggregate tables with the dimension. And join should not be there between the aggregate tables(we can not connect the two facts)
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / manasa
To give joins to the aggrigate tables in the universe when we want to use aggregate aware function.Aggregate aware function is used to pool the columns from different tables.
| Is This Answer Correct ? | 1 Yes | 8 No |
1) How to get multi values in a single prompt? 2) How to get ALL in @prompt? 3) Select 1 from fact table? What will be the result? 4) I have created 1 universe say A and generated 100 reports on the universe? Later i had renamed the Universe as A1 and added some objects? Now how i will get the newly added objects in old reports?
What is report template in b.o?
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?
How can we do load testing for webi reports? (Example if I have have to test one webi report for concurrent users refreshing report at one time)?
What are the steps to be taken to schedule the report?
I need to select the rows based on the latest 'Payment_due_date' column value. Let's say I have a Deski report with 3 columns: Payment_due_date, Cust_Name, Oustanding_Amt. Report is like this: ===================================== Payment_due_date,Cust_Name,Oustanding_Amt 02/28/11 , Bob, 115 03/31/11 , Bob, 90 02/28/11 , Mike, 120 02/28/11 , Susan, 220 05/31/11 , Bob, 80, 03/31/11 , Susan, 70 05/31/11 , Mike, 220 05/31/11 , Susan, 120 04/30/11 , Susan, 130 So,we would like to see (based on latest Payment_due_date) ================== 05/31/11 , Bob, 80, 05/31/11 , Mike, 220 05/31/11 , Susan, 120 Oustanding_Amt comes as SUM(Oustanding_Amt) from Universe. If we use Max(Payment_due_date),we do get one row but then, the column 'Oustanding_Amt' sums up. Not allowed to use do SQL Override .Context Operators aren't working. Thanks in advance:)
How to resolve the partial result error in the report
whats the diff between break and section
I have a report with some hyperlinks,any issue will i get when i migrate this report?
how to schedule a report for even number dates?
What services the broadcast agent offers on the server side?
Explain what are the steps to do to use alerts in bo?
Teradata 
