Steps to create alias and apply

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


Please Help Members By Posting Answers For Below Questions

what is the difference between add link and include link in BO? Explain me with a scenario when to go for add link and when to go for include link?

9882


BO Security (creating the restriction sets in Universe and applying on selected groups or users) or Database security (Creating the tables in database insrting the user details in that tables and giving conditions in self restricting joins in Universe )Which Security will improve the performance of the reports and for best practices ? I am thinking BO Security will give the better performance, could you please share your thoughts on this please... Thanks...

1725


is it possible to export the webi reports to crystal reports?with out using businessview?

1820


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

4450


Explain is data mart?

596






What are the join problems comes appart from loop,chasm & fan Traps

1556


I have set of reports in BO4.0 and need to use "Hyperlink" functionality. I had to use native hyperlink functionality provided in BO4.0 but looks like it's available only in Rich Client.Currently,we have only Infoview B04.0 Launch Pad.Is OpenDoc the only hyperlink option on BO4.0 Launch Pad? Thank you.

2999


Hi friends, I am trying to create OLAP connection in IDT. I am getting error "error code:405 METHOD NOT ALLOWED" I am using "http:/olap/msmdpump.dll" I am using ms sql server 2012 -- cube

3289


What if a cartesian product pop up block appears when running a report. Does it give wrong values? How to solve this issue?

598


What is the dense rank?

679


Explain about a time when you discovered a more efficient way to do a work task?

641


Explain about a task that really tested your analytical abilities?

757


Hi, What is the best answer for tell me about yourself for 2 years experience in bo developing.

3847


What is difference between webi and infoview?

617


What Is The Difference Between Oltp And Olap?

681