cancel
Showing results for 
Search instead for 
Did you mean: 

SSM7.5 - Dimension with Multiple Hierarchies

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (1)

Answers (1)

0 Kudos

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

Former Member
0 Kudos

Hi Shashi,

first of all, thanks for your answer.

But I don't understand when you say that "we cannot have two hierarchies on the same dimensions"?!?!?

I already have some years of experience with PAS database and it's not the first time I create a dimension with more than one hierarchy. I use also that in a productive system (before this SSM front-end) without problems. And in this latest version of PAS (version 7.5.6) it's still possible to use that feature. As you can see in my initial post, I put two screen shots of the dimension with two hierarchies in PAS dataview, and works fine, without problems in the drill-down/up.

From PAS online help:

HIERARCHY is a Dimension command that defines the members and levels that comprise a particular hierarchy level within a dimension. It also allows multiple consolidation structures that stem from a central root of inputs. Use hierarchies when the input members are consolidated into more than one output member. When a dimension has hierarchies, members can have more than one path for rolling up into output levels. If a dimension has only one hierarchy, no HIERARCHY statement is necessary.

Based on this, I create my example of a dimension (named MULTI) with two hierarchies (REGION and TYPE). Maybe the name I use for the second hierarchy create some confusion to you, because of the TYPE dimension that can exist in SSM. I just hope the problem I'm having in the SSM front-end is not related with the name I used for the second hierarchy!!!!

I will rename that and test again.

Regards

Pedro

former_member84747
Participant
0 Kudos

Hi Pedro,

You're correct that you can definitely have multiple hierarchies in a PAS dimension, though to be honest I doubt that anyone has done so in a considerable period of time. This is mostly because Cube Builder does not provide for creating multiple hierarchies, nor does E&A support it. So anyone using multiple hierarchies would need to implement them manually.

That said, it looks like you've hit some sort of limitation - likely something we simply haven't tested in more recent product versions. Can you please open a support message for this?

Thanks in advance.

Robert

Former Member
0 Kudos

Hi Robert,

some people still hand made the PAS databases

I remember to use this solution in PAS database in the past (9 years ago, I think) and the solution works fine at that time. I try to use that solution now in SSM only to see if it was still possible to use. It's not very common to have a customer that needs this implemented, but we never know.

We will raise this as a support call.

Thanks for your help

Regards

Pedro

former_member84747
Participant
0 Kudos

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