Finance | Project Operations, Human Resources, ...

How to get the Dimensions for records in the CustTrans table

(0) Share

Report

Posted on by CU14081545-0

I need to be able to pull together all Customer Transactions along with the dimensions for each Transaction. I am pulling the data from the data lake into Power BI.

I can see there is a link to "DefaultDimensionView" table and this works. However this is not available on the data lake export. Is there another way to get the dimensions per Customer transaction?

Any help would be greatly appreciated.

Many Thanks

I have the same question (0)

All responses (2)

Answers (0)

Suggested answer

nunomaia 25 Moderator on at

Like (1)

Report
Copy link

Link copied!

Main tables of DefaultDimensionView are DimensionAttributeValue and DimensionAttribute.

If you have access to a dev box, you can open in SQL Server view and check how is created and recreate in Power BI Side

Was this reply helpful? Yes No
Suggested answer

GirishS 27,829 Moderator on at

Like (1)

Report
Copy link

Link copied!

Hi KevBar,

In addition to Nuno Maia comments refer to the below tables.

CustTrans, DimensionAttributeValueSet, DimensionAttributeValueSetItem, DimensionAttributeValue, DimensionAttribute.

Just try to join the above table to get the default dimensions for the customer transaction lines.

Thanks,

Girish S.

Was this reply helpful? Yes No