Skip to Content
author's profile photo Pedro Costa
0
Pedro Costa

SSM7.5 - Dimension with Multiple Hierarchies

Posted on Sep 13, 2010 at 09:02 AM 15 Views

Hi all,

I'm facing here one problem in the SSM front-end when I'm trying to use one the possibilities that PAS database offers, in this case the use of a dimension with multiple hierarchies.

As you can see in this image, the dimension is created in PAS and works without problems in the dataview.

Hierarchy one:

[http://img121.imageshack.us/img121/334/pas1y.jpg]

Hierarchy two:

[http://img831.imageshack.us/img831/2586/pas2.jpg]

In the SSM front-end, when I try to use that dimension, by default appears the first hierarchy:

[http://img826.imageshack.us/img826/4043/hier3.jpg]

In the dimensional selector the dimension appears fine for the first hierarchy:

[http://img30.imageshack.us/img30/3103/hier1.jpg]

But when I select the second hierarchy...

[http://img34.imageshack.us/img34/1722/hier2.jpg]

The Internet Explorer crashes and close all the open windows. This happens in the scorecard and also in the reports.

Is not possible to use dimensions with multiple hierarchies in SSM? Did anyone had this problem before?

Thanks in advance

Pedro

Edited by: Pedro S. Costa on Sep 13, 2010 11:03 AM

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

1 Answer

  • author's profile photo Shashikant Sangalad
    Shashikant Sangalad
    Posted on Sep 22, 2010 at 09:54 AM
    0

    Hello,

    First of all we cannot have two hierarchies on the same dimensions.

    But you can have user defined hierarches (virtual sub hierarchies based on the existing hierarchy data) which you can use in the scorecar and reports.

    The second hierarchy is based on the dimension TYPE. TYPE dimension is used for BENCHMARKING and hence when you are trying to see this dimension in scorecard, it is crashing.

    hope this helps.

    Best Regards

    Shashi

    Add a comment
    10|10000 characters needed characters exceeded

    • Robert Holland Pedro Costa
      Oct 12, 2010 at 02:39 PM

      Hi Pedro,

      I know you've been using this a long time, and that some people still remember the full functionality of the product. 😊 And yes, I also know that this used to work, so I'm not sure when it stopped, which is why the support message would be good.

      Thanks again,

      Robert

      Edited by: Robert Holland on Oct 12, 2010 4:39 PM

    Comment on This Answer

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.