Visualization tab shows dimension twice after merging dataset

[Former Member]

Hi,

We are using Lumira 1.29 desktop and LSBIP 1.29. I have extracted and created a dataset based on a fact table from SQL server , later I used the merge option to join the fact table to the Master data tables based on the PK and FK logic (Country Id as FK in fact and Country Id as PK in Master data table). I was successful in merging but in the Prepare tab we had 2 Country ID columns after merge and I was able to hide one of them in the Prepare tab.

The issue is when I went to the visualization tab I see that we have 2 Country ID when I click on the '+' symbol under dimension.  I need to show only one as the user would see 2 same dimensions and would be confused as to select which one.

The result/output is the same when we use either one.

[TammyPowlas]

Maybe share details of how you merged?  Use the camera icon to upload a screen shot

[Former Member]

Tammy,

After I extract the data, I click on the merge icon on top left and then add a new dataset from the merge window and match the PK and FK.

[Former Member]

Tammy,

In the attached screenshot the dimensions were already merged , I added to show you how I did the merging.

[TammyPowlas]

Thank you for the images

I am having a hard time replicating this; are you on 1.29.3?

[Former Member]

Yes Tammy , 1.29.3 Build 99

[Former Member]

Tammy , fyi -- The SQL server data is extracted through the Universe created in IDT as Unx

[TammyPowlas]

I don't have SQL server data in a universe; is it possible to do join this back in the IDT/semantic layer and then report in Lumira?

[Former Member]

Tammy - I am sorry for not been clear in the first place.

We have created a universe with SQL server as the database, the tables were inserted and joins on the table are done in the data foundation layer and created business layer and then I published the  business layer to BO repository as UNX file.

In Lumira, I used the "Connect to universe option" to create the Lumira dataset

Regards

Raj

[TammyPowlas]

Back in the IDT/Business Layer, does the ID show up twice there when you try to run a query?

[Former Member]

In Business layer, I have the same dimension (ex. CustomerID) in 2 different class (One is Fact Table class and other in Master table class) and when I run the query I use from either one of the class to fetch the data. Hence while running the query it shows up once.

Also in Lumira under prepare tab I have hidden both the dimension in respective dataset, but I still see them in the dimension list under Visualization tab when I click on the + to add the dimension while creating visualization

Please  let me know if I am not clear.

Regards

Raj