Skip to Content
avatar image
Former Member

Hierarchies in SPM-Queries

In the SPM Queries there are Hierarchies enabled for certain characteristics.

So far we have not maintained these in the backend. Now in certain SPM reports or dashboards we get errors due to that hierarchies not being available.

Therefore I would like to understand if these hierarchies are kind of mandatory for SPM, or if I can just delete them in the queries if they would never be created anyways?

Furthermore I would like to understand in general how SPM deals with hierarchies. Is there any documentation available on that topic?

Thanks again in advance,

Tobias

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Mar 24, 2011 at 11:11 AM

    Hi Tobias,

    Yes, you are right for certain characteristics in SPM Queries have hierarchies. And these dimensions are part of certain out of the box reports. So removing these hierarchies from the query will not fix the out of the box reports, as these reports are expecting the hierarchies to be present. But when users are creating new reports they will not receive that error anymore.

    The only difference the way BW hierarchies are displayed is only one level is displayed in SPM UI at any given time.

    Regards,

    Rohit

    Add comment
    10|10000 characters needed characters exceeded