Page 1 of 1

TM1 Query for Dimension Element

Posted: Mon Oct 28, 2013 2:15 pm
by Shazin
DearExperts, I am a beginner in TM1 and have developed a process that fetches data from an Oracle database and populates a cube.

One of the measure that I can see if coming up as greyed which I am not able to uderstand why as it is not a Rule or Process derived column. I want this Budget to be put in by business.

Please can you guys have a look into th escreenshot and advise.

Cheers,
Shax.

Re: TM1 Query for Dimension Element

Posted: Mon Oct 28, 2013 2:49 pm
by tomok
I assume you are talking about R130 - Gross Passenger Revenue? That element is a consolidation. You can't directly enter data into a consolidated node (that's why it is greyed out). You can, however, use data spread functionality into that cell.

Re: TM1 Query for Dimension Element

Posted: Mon Oct 28, 2013 2:52 pm
by jim wood
Tomok,

I think the user means the whole column that is greyed out. The only problem is that we can't see what selections you have made for any other of the dimensions as they are hidden in your screen shot. My guess would you have a consolidation selected there,

Jim.

Re: TM1 Query for Dimension Element

Posted: Mon Oct 28, 2013 2:54 pm
by Shazin
Hi Guys,

Sorry my bad. I got this sorted out. Reason was the same. One of the selection was consolidation.

Cheers,
Shax