SAP Knowledge Base Article - Public

2670630 - Missing attribute of account dimension in filters

Symptom

In the account dimension 10 attributes are defined.

When attempting to select these attributes in a filter of a story only a subset of the attributes are available.

Environment

  • SAP Analytics Cloud 2018.12.1

Reproducing the Issue

  1. Modify an account dimension and add a number of additional columns to be used as filters.
  2. Create a story based on a model that uses the above account dimension.
  3. Filter the story by account and expand the attributes. Only a subset of the attributes will be visible for use.

Cause

Problem with regeneration of dimension when adding new columns (attributes) to an existing dimension.

Resolution

The following work around can be applied while development investigates a fix.

 

Worakround:

  1. Open the modeler area and open the financial planning model
  2. Open any other dimension, other than the account dimension
  3. Create a new column (which is equal to adding a new attribute)
  4. Save the model
  5. Go to the stories and you should be able to see all the attributes

Clean up the work around:

  1. Go back to the model and the dimension in which you added a new attribute (column)
  2. Delete the column
  3. Save the model

See Also

Your feedback is important to help us improve our knowledge base.
Please rate how useful you found this article by using the star rating feature at the beginning of this article.
Thank you.

Keywords

SAP Cloud for Planning, sc4p, c4p, cforp, cloudforplanning, EPM-ODS, Cloud for Analytics, Cloud4Analytics, CloudforAnalytics, Cloud 4 Planning, BOC, SAPBusinessObjectsCloud, BusinessObjectsCloud, BOBJcloud, BOCloud., SAC, SAP AC, Cloud-Analytics, CloudAnalytics, SAPCloudAnalytics , KBA , LOD-ANA , SAP Analytics Cloud , LOD-ANA-BI , SAP Analytics Cloud - Business Intelligence (BOC) , LOD-ANA-PL , SAP Analytics Cloud – Planning (BOC) , LOD-ANA-BR , SAP Analytics Cloud - Digital Boardroom , LOD-ANA-PR , SAP Analytics Cloud – Predictive (BOC) , Problem

Product

SAP Analytics Cloud 1.0