Answer Posted / mysticbo
Hi All,
I am new to Universe designing.
I have detected loop. And after reading forums,I understand
I need to create alias of the required table.
I have a few questions:
1) Suppose I create an alias of the table
as "table_name_alias" and create the necessary joins,what
is the next step?
2)DO I need to link the alias table with the original
table? ---No I think
3)DO I simply go to my semantic layer and change the object
definition of the original table and point it
to "table_name_alias".
Will 3) be sufficient if I dont have too many facts tables?
Or do I need to drag the "table_name_alias" and create a
class of that?-- I think NO
Please guide.Thanks:)
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
What is the difference between condition & filter?
What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
Explain what if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?
If I have three predefined prompts. In a report it will come randomly. How they will come in a specified format?
(1) Is it possible to create measures using objects from different context. (2) If cross context measures are not possible then what about @aggregate_aware() function ,here we use objects from different contexts. (3)Two measures from two different context ,can they be summed at report level.
Are data mart and dwh normalized or denormalized? Do both of them exist in the same tier?
U r project in which stage in implementation?
Explain how to schedule the report in b.o?
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
Hi I'm using data federator.I would like to know if it allows select statment in where clause.For example: SELECT Employee, company, orgunit FROM TAB_BIG WHERE employee IN (Select TAB_SMALL.employee FROM TAB_SMALL WHERE flag = X ) bye
How to generate the report from excel sheet?
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 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?
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....