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

Unable Nest dimensions in Analysis studio

Started by zulfi123786, 25 Dec 2013 04:37:09 AM

Previous topic - Next topic

zulfi123786

Hi,

I am very new to Cognos and trying to understand how to work with Analysis Studio.

I am working over Sales and Marketing cube provided with the tool and my current Analysis has

1. Time(2010,2011,2012,2013) in columns
2. Revenue as measure
3. First dragged Retailers into rows which shows up Americas, Central Europe, Asia Pacific, Norther and Southern Europe
4. Added E-mail and web from Order Method dimension and nested it into above rows.
5. Appended Products Dimension(Camping, Mountaineering, Personal Accessories ...) below the existing rows as stacked set
6. Now the problem is that it's not allowing me to nest "fax" and "telephone" from order method dimension into the added Products dimension.
7. If I delete the first nested set (Retailers + "E-mail" & "web") then I am able to nest "fax" and "Telephone" into Products dimension

Could some one please help me understand why I cant nest multiple sets.

MFGF

Hi,

There is an inherent limitation in Analysis Studio that prevents you from nesting more than three levels deep. The idea is that you use Analysis Studio to perform discovery and analysis rather than to build a detailed crosstab. If you want to nest more than three levels, try using Cognos Workspace Advanced instead of Analysis Studio - CWA doesn't have this limitation.

Cheers!

MF.
Meep!