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

Level names not appearing in the Report Package

Started by Varshini Niharika, 29 Aug 2013 01:56:39 AM

Previous topic - Next topic

Varshini Niharika



Hello Team,

In an OLAP/DMR Model, the Level names come under each Hierarchy specified for the Cube Structure.

In our Cognos Environment of Cognos BI 10.1 Report studio which as Cognos TM1 as the Source - The Levels names are not appearing under the Hierarchies of the Cube in the Report Package as shown Below


The Package Tree Settings also Set for default: with Members,Levels & Members for Each Level,Member Properties

The Package is re-published again with all the required settings(Framework Manager)

The TM1 services restarted, & also the Hierarchy Properties Set in the TM1 (Level names)(Cube Data Saved).


Please let us know what are we missing, as that the Level Names are not appearing in the Report Package.

MFGF

Hi,

It looks to me like level names have not been successfully implemented in your TM1 cube.

You might want to check that you have:

a. Edited the {HierarchyProperties system cube to add all the desired names for the levels of each dimension
b. Refresh the desired dimensions/cubes in TI and in the TI process use the RefreshMdxHierarchy([dim name]) function - either for each dimension or RefreshMdxHierarchy('') for all dimensions.

The recommendation is that named levels are used where you have balanced hierarchies with only one member in the root level.

Cheers!

MF.
Meep!

Varshini Niharika

HI,

Hey that did Work  :D adding the above Second Pointer in the TI Process.

Added the RefreshMdxHierarchy('') in one of the TI process..to reflect for all the dimensions.

Thanks a Lot.

;)