Measure Dimension - creating folder structure

Post Reply
krithika331
Posts: 44
Joined: Thu May 01, 2014 12:46 pm
OLAP Product: Cognos TM1
Version: 10.2
Excel Version: 2010

Measure Dimension - creating folder structure

Post by krithika331 »

Hi,

We have measure Dimension, which requires to maintain the folder structure hierarchy. Lets say for example we have YTD measures, it should be put in a grouped folder as 'All YTD' and for cost measures under a separate folder. According to me we can create the levels in hierarchy properties cube but not the folder level structure. Any ideas ??


Thanks in Advance
lotsaram
MVP
Posts: 3706
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Measure Dimension - creating folder structure

Post by lotsaram »

What on earth are you talking about? Without a coherent question how can you expect help?
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
dr.nybble
MVP
Posts: 160
Joined: Wed Aug 17, 2011 3:51 pm
OLAP Product: TM1
Version: 10.2.2
Excel Version: Excel 2007

Re: Measure Dimension - creating folder structure

Post by dr.nybble »

I assume you are trying to create a Transformer-like measure dimension where measures are grouped into measure folders for organization purposes.

Well in TM1 there are just dimensions. You can create a hierarchy in the measure dimension if you like to group measures together.

You may need to use cube rules if you don't want measure values to show up under your "consolidated" nodes in the dimension.

There is no extra metadata that allows you to make a measure appear as a folder in BI studios.
tomok
MVP
Posts: 2836
Joined: Tue Feb 16, 2010 2:39 pm
OLAP Product: TM1, Palo
Version: Beginning of time thru 10.2
Excel Version: 2003-2007-2010-2013
Location: Atlanta, GA
Contact:

Re: Measure Dimension - creating folder structure

Post by tomok »

There is no such thing as a folder in a multi-dimensional tool like TM1. I am assuming you are talking about grouping nodes under a common parent (with the parent being called a "folder"). If you don't know how to create parents and put nodes under them then you need to read the manual and/or take a training class. This is about as elementary as you can get with the tool. No one is going to waste their time with someone so lazy they can't bother to read a manual or take a training class.
Tom O'Kelley - Manager Finance Systems
American Tower
http://www.onlinecourtreservations.com/
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Measure Dimension - creating folder structure

Post by jim wood »

While the points above are little direct they are also true. Could you please read the guidline for requesting assitance? This will help you get the best possible help out of the experts on the forum.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
Post Reply