Links in QV

[#1]

Hello,

I'm having several tables that are coming from a flat datamart. Several key fields are doubled because the facts tables can reach any dimension table in 1 join. Of course some dimension tables can reach other dimension tables too.

Here QV makes the joins to complicated by creating these $Syn fields.

Is there a way i can help QV with this. Because i'm getting an error while loading the data, and at this moment the data is a source for over 50 SSAS cubes, so i know that there is no problem with it.

[#2]

Hi,

what you can do is rename a field by using AS like:

Customer as CustomerName

to avoid a link between tables.

Maybe you need a combined key like:

ZIPCODE &'_' & COUNTRY as %%COUNTRYKEY

See also the QV HELP file and search for QUALIFY (Unqualify).

Rainer

[#3]

Ok, We are evaluating QV, I'll describe my data, if you have time maybe you could get me help started ..

Table 1 Movies, Mov_UI, Mov_Name, Comp_UI, Cou_UI

Table 2 Complex, Comp_UI, Comp_name, Cou_UI

Table 3 Country, Cou_UI, Cou_Name

The Cou_UI From the Complex makes a link to the Country as from where the Complex is Located, the COU_UI in the movies is the origin from the movie.

In regular Cube Building i can give these relations a name ....

[#4 · Accepted solution]

Hi,

please see the attached application.

Are the relations between the tables correct?

Rainer