I am facing an issue while trying to retrieve financial Dimension Values for Store Dimension. It is standard and mapped to RetailStore Table.
Here are all the dimensions visible on the DimensionDetails form.
but on Entity only 5 are visible.
I noticed Values appear here after I edit and save the DimensionDetails page. after some debugging, I found that it is not populated on the DimensionattributeValue table in the first place.
What is the standard way to populate the financial dimension tables?
Else I have to use BackingEntity table to get all the possible dimension value.
I checked an export and noticed the same in an 10.0.35 environment. The DimensionAttributeValue table should not have all dimension value records, only when they are used. For that reason, this entity is only exporting the dimension values when they were actually used.
If you need a data entity with all store values, you can consider creating a custom data entity.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
928
Share
Report
All responses (
Answers (
