Need help in TM1 dimensions

Post Reply
rasika
Posts: 4
Joined: Wed Sep 15, 2010 7:12 am
OLAP Product: tm1
Version: 9.4
Excel Version: 9.4mr1

Need help in TM1 dimensions

Post by rasika »

Hello All,
I am new to TM1 tool,I need your help.
I am doing POC on TM1, in that below data I am using.
  • Product INGCountry EDCountry EDPrice Formula Used
    Product 1 Algeria France 10 Average
    Product 1 Algeria Italy 20 Average
    Product 1 Algeria Morocco 14 Average
    Product 1 Algeria Netherlands 34 Average
    Product 1 Algeria Spain 29 Average
    Product 1 Algeria Tunisia 45 Average
    Product 1 Algeria United Kingdom 23 Average
    Product 1 Bahrain Algeria 25 2nd Lowest
    Product 1 Bahrain Argentina 30 2nd Lowest
In above data If Algeria Country has Formula as "Average" so all the EDPrice values coming under Algeria should become Average i.e. 25 and if Bahrain formula is "2nd lowest" so value should be 25.
These values will get stored in other element.

I am really not sure how to use rules,which columns should be in dimensions and which should be use as data for above requirement as requirement is very generic.
Formulas can be changed,Number of EDCountries can be changed,so everything should be dynamic.

Anyone can help me on this :?
Top
Tm1andTm1
Posts: 48
Joined: Thu Apr 11, 2013 7:47 am
OLAP Product: Cognos TM1
Version: 10.2
Excel Version: 2010

Re: Need help in TM1 dimensions

Post by Tm1andTm1 »

Strange !!!

No TM1 Expert has replied to this mail......... :)
Top
rmackenzie
MVP
Posts: 733
Joined: Wed May 14, 2008 11:06 pm

Re: Need help in TM1 dimensions

Post by rmackenzie »

Tm1andTm1 wrote:Strange !!!

No TM1 Expert has replied to this mail......... :)
The question has a ring of 'help me do my job even though I am completely out of my depth'. Also there are several questions rolled into one such as what the dimensions should be, which columns in the dataset are actually data and whether use of TM1 rules would be appropriate. That's quite a lot of questions to roll into one.

People tend to answer questions that have a ring of 'help me with this technical problem I am stuck on, even though I've tried a couple of things already'...

The OP should check the guidelines to follow when requesting assistance.
Robin Mackenzie
Top
lotsaram
MVP
Posts: 3702
Joined: Fri Mar 13, 2009 11:14 am
OLAP Product: TableManager1
Version: PA 2.0.x
Excel Version: Office 365
Location: Switzerland

Re: Need help in TM1 dimensions

Post by lotsaram »

Tm1andTm1 wrote:Strange !!!

No TM1 Expert has replied to this mail......... :)
Why don't you give it a go?
Please place all requests for help in a public thread. I will not answer PMs requesting assistance.
Top
Tm1andTm1
Posts: 48
Joined: Thu Apr 11, 2013 7:47 am
OLAP Product: Cognos TM1
Version: 10.2
Excel Version: 2010

Re: Need help in TM1 dimensions

Post by Tm1andTm1 »

lotsaram wrote:
Tm1andTm1 wrote:Strange !!!

No TM1 Expert has replied to this mail......... :)
Why don't you give it a go?
Nice solution Mr MVP..........we are here to learn something from TM1 experts.
Top
Paul Segal
Community Contributor
Posts: 312
Joined: Mon May 12, 2008 8:11 am
OLAP Product: TM1
Version: TM1 11 and up
Excel Version: Too many to count

Re: Need help in TM1 dimensions

Post by Paul Segal »

Troll.
Paul
Top
Post Reply

Return to “IBM TM1, Planning Analytics, PAx and PAW”