Interested to Buy Any Domain ? << Click Here >> for more details...
i Have created the universe in which i have one table and
different derived tables from the same table i am supposed
to create report from the same universe which should
dispalay the duplicates rows, but all the time i run the
report i am not getting the duplicate rows i have checkd
the duplicate report option too in report.. is there
problem with universe or report,.. can any body help?
- 2 Answers
- 6703 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / senthilmurugan.s
This can be solved in a simple manner.. In Report just
double click your table or right click for Table
properties.. In the General Tab just uncheck the
option "Avoid duplicate rows Aggregation". Hope you will
get the desired results..
--Senthilmurugan.S
| Is This Answer Correct ? | 4 Yes | 0 No |
Answer / dhineshkumar. s
I thing, the plm is in universe, there is only one table is
used in the universe and all other is derived tables. where
you get objects? if you get objects from derived tables
alone pls check the join condiion in derived table's sql
query, else if you are pulling objects from derived table
and db table, definitly you would get duplicate rows.
| Is This Answer Correct ? | 0 Yes | 1 No |
Explain which versions are used in the bo dashboard work?
How can you check the universe?
what is tuning of business reports ?
5 Answers Business Intelligence Analytics, Oracle, TCS,
Once the project is submited to the Client. Client says that report is taking long time to run? Where u need to check?
I have one vertical table and in that table there are 10 rows. I want to add one row between 4-5 row. How it possible in WebI.
How to Avoid the overlaping the blocks in WEBI.
how do u resolve contexts ?
Hi,can anybody help me to do like this, i have one dp with agerange, first name ,Address. And another dp is agerange,age min , last name. in this two data providers agerange is common . I want to see in my report all the fields . How i can merge it ?
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:)
When we go for OLAP , and When we go for OLTP for generating the reports ?
disadvantages of boxi
What is scope of analysis ?
Teradata 
