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.
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.