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?
Answer Posted / 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 |
Post New Answer View All Answers
Which command using Query Analyzer will give you the version of SQL server and operating system ?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
What are all the points to keep in consideration, while we are migrating the Universes,Reports from BO5.1.6 to BO 6.5? Is is compatible to migrate like this? Does it effect the filters in Reports and Join in the Universe?
How much data hold in one universe 336 can any one explain about core dimension, balanced dimension, and dirty dimension?
What is package in BO
What is difference between webi and infoview?
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
How to execute the plsql procedure from the report by clicking with mouse?
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?
Explain are data mart and data warehouse normalized or denormalized? Do both of them exist in?
Can any one say me how i can integrate 3 or more analytics like radio bottons,line chart,pie chart while designing a dash board in xcelsius and i am also facing problem to show one after another values in the same chat at a time..... Please help me out for this....
what is the difference b/w the refresh and buffered data?
any difficulitis have you phase while creating bo reports and how did u solve it
IN THE REPORT I WANNA APPLY HYPERLINK FOR A CELL IN THE COLUMN/ROW HOW TO ACHIEVE THIS? EG: YEAR COLUMN : 2001,2002,2003,2004 I WANNA APPLY FOR 2001 ONLY
Explain when to use local filter and when to use global filter?