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

Categories:

Other

Financial Management

Data Integration

All responses (2)

Answers (0)

Suggested answer

GirishS 27,828 Moderator on at

Like (1)

Report

RE: How to get the Dimensions for records in the CustTrans table

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.
Suggested answer

nunomaia 10,684 Moderator on at

Like (1)

Report

RE: How to get the Dimensions for records in the CustTrans table

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