How do I retrieve Display value and the corresponding Name of a Dimension?

(0) Share

Report

Posted on by PhucNguyen

I need to write a select clause or build a view to get DisplayValue field from DimensionAttributeValue table and the corresponding Name value which come from the table name in BackingEntityType field of DimensionAttribute table.

Anyone have some ideas?

I have the same question (0)

All responses (5)

Answers (1)

Suggested answer

Adria Ariste User Group Leader on at

Like (0)

Report

Hi,

you can use the DefaultDimensionView and look for the values using the dimension's name.

Regards,

Adrià Ariste - Senior technical consultant @ Axazure - Read my blog!

Was this reply helpful? Yes No
Suggested answer

Sumit Loya 2,230 on at

Like (0)

Report

Hi,

If you have DefaultDimension then you can use DefaultDimensionView to get the required data. If it is LedgerDimension then you can use DimensionAttributeLevelValueAllView along with DimensionAttribute to get your required data.

Was this reply helpful? Yes No
PhucNguyen 35 on at

Like (0)

Report

I mean, the Name of Dimension values, not of Dimension types.

Like this:

I need select '001' value with 'Home' value, not 'BusinessUnit' value

Was this reply helpful? Yes No
Suggested answer

Adria Ariste User Group Leader on at

Like (0)

Report
If the dimension has a backing entity (like Customer, Project, etc.) you can just get the value from that entity table, otherwise you need to find the value from the DimensionFinancialTag table in the following way:

select firstonly dimensionAttribute where dimensionAttribute.Name == DIMENSIONAME join dimensionAttributeDirCategory where dimensionAttribute.RecId == dimensionAttributeDirCategory.DimensionAttribute && dimensionAttributeDirCategory.DirCategory join dimensionFinancialTag where dimensionFinancialTag.FinancialTagCategory == dimensionAttributeDirCategory.DirCategory && dimensionFinancialTag.Value == DIMENSIONVALUE;

Adrià Ariste - Senior technical consultant @ Axazure - Read my blog!

Was this reply helpful? Yes No
Verified answer

Sumit Loya 2,230 on at

Like (1)

Report

Hi,

On DefaultDimensionView, you can see a display method "dimensionDiscription". This will return what you need. So you can still use DefaultDimensionView for your dimension values.

Was this reply helpful? Yes No