Traditional web-based reporting with SAS BI tools

Member proporty statement in OLAP

Reply
Frequent Contributor
Posts: 115

Member proporty statement in OLAP

I am using below property statements in my OLAP cube.

PROPERTY          forecast_point_city_nm

                  LEVEL=forecast_point_desc

                  COLUMN=forecast_point_city_nm

                  CAPTION='Forecast point city name'

                  HIERARCHY=(dim13ForecastPoint) ;

PROPERTY          component_desc

                  LEVEL=component_id

                  COLUMN=component_desc

                  CAPTION='Component text'

                  HIERARCHY=(dim14Component) ;

When loading into the Cube, got below error for component_desc property.

ERROR: More than one distinct property value was found for property "component_desc" assigned to the same member in the

       "component_id" Level of the "dim14Component" hierarchy.

For work around, component_desc value is changed with unique values to have one-to-one map with component_id

Could you please let me know, if there is any permanent solution, instead of change the “component_desc” value

Ask a Question
Discussion stats
  • 0 replies
  • 224 views
  • 0 likes
  • 1 in conversation