Skip to Content
author's profile photo Former Member
Former Member

Working of Alias

Hi All,

i am working on BOXI R2, i have already existed universe with one fact table and many dimensions. there is no loops its working properly. i got new requirement on same universe, added the new table then i got loop. i resolved it by alias.

Existed

Assume tables like Fact F, Dimensions D1 and D2

joins F-- -D1 and F --


D2

New Requirement

new table D3

joins D1--


D3 and D2--


D3

Loop is D3---- D1


F-- -D2 -- -D3, i made D3 as alias. i resolved the loop like D3Alias
D1

F

D2
-----D3

My question is, if i select the fields from D3 what r the joins are picked.

If I am not clear, i will explain with better example.

Thanks.

Add a comment
10|10000 characters needed characters exceeded

Related questions

2 Answers

  • author's profile photo Former Member
    Former Member
    Posted on Nov 10, 2011 at 11:00 AM

    Hi,

    Upto my understanding,

    You can provide short cut join to D3 from D1 and D2 seperately.

    Regular join from F to D1 and D2 sepeartely.

    If u choose D3 with combination of F and D1 it will consider F to D1 to D3 and also vice versa.

    For applying short cut join right click on join between D1 and D3 and choose short cut join option.

    Reagrds,

    Ragoth.C

    Add a comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi Me map,

      But what u told is

      "Shortcut joins are used to shorten join paths where possible, not to resolve loops.

      They are performance enhancements."

      For that only I posted the shortcut join definition.

      Anyhow now I am very much clear about the shortcut joins and in which circumstances it can be used after this discuission in this thread.

      Thanks and Regards,

      Ragoth.C

  • Posted on Nov 14, 2011 at 11:03 AM

    Hi,

    The question you need to ask is:

    What is selected when you go from F to D1 to D3?

    What is the functional meaning of what you pick up out of D3 then.

    Is it the same or something else if you go from F to D2 to D3?

    Lets assume D1 and D2 are Customer and Company.

    D3 is an address table.

    Then D1 to D3 will give you a Customer Address,

    D2 to D3 will give you a Company Address.

    In this case the alias is fine and you create objects from the D3 joined to D1 and put them in a class Customer Address.

    Similar you create a class Company Address for the objects coming from the D3 joined to D2.

    So the user will be able to pick the information they are interested in and the join is chosen accordingly.

    If it would be same information independent of F - D1 - D3 or F - D2 - D3 then a shortcut join is an option.

    Lets say D1-D3 is a normal join and D2-D3 is the shortcut.

    Then you will have just one set of objects and if the user selects objects from D1 and D3 the normal join will be used, but if they only select objects from D2 and D3, the shortcut join will be used.

    Hope this is clear enough,

    Marianne

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.