If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

Duplicate levels under one dimension in Report studio

Started by diana, 30 Aug 2017 01:08:55 AM

Previous topic - Next topic

diana

Hello guys,

New to transformer and was playing around with test data. Found a strange thing and I don't know how to restore it although it doesn't impact analysis studio.

I created a dimension called Product Group, under it there are two levels.
Product Group=>Product Code

but I see two levels of product group in the package opened in report studio. attached the screenshot. The hierarchy tree seems still ok in analysis studio.
The only reason I can think of that might cause this is I've deleted product code once and put it back again.

I wonder if anyone knows if that was the root cause? and if I want to remove the duplicate level, what to do?

Thanks guys.

MFGF

Quote from: diana on 30 Aug 2017 01:08:55 AM
Hello guys,

New to transformer and was playing around with test data. Found a strange thing and I don't know how to restore it although it doesn't impact analysis studio.

I created a dimension called Product Group, under it there are two levels.
Product Group=>Product Code

but I see two levels of product group in the package opened in report studio. attached the screenshot. The hierarchy tree seems still ok in analysis studio.
The only reason I can think of that might cause this is I've deleted product code once and put it back again.

I wonder if anyone knows if that was the root cause? and if I want to remove the duplicate level, what to do?

Thanks guys.

Hi,

You're missing one important piece of information here. In all dimensions in Transformer there is always a single member in a level at the top of the hierarchy - the root category. You can see this if you look at the category diagram in Transformer. You don't ever define this - it is always there. The level this member lives within adopts the name you give to the dimension. If you have named the dimension "Product Group", then the top level with the root category in it will be called "Product Group". If you then have a Product Group level defined within the hierarchy for the real Product Group members, it needs a unique name, so it automatically gets renamed to Product Group 1. This looks to be what you're seeing here.

The simple fix is to rename the dimension (at the top of the Dimension Map window) to be Product Groups, or All Products, or something that you won't confuse with the real Product Group level.

Cheers!

MF.
Meep!