TM1 Query for Dimension Element

Shazin · Post by **Shazin** » Mon Oct 28, 2013 2:15 pm

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.

tomok · Post by **tomok** » Mon Oct 28, 2013 2:49 pm

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.

jim wood · Post by **jim wood** » Mon Oct 28, 2013 2:52 pm

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.

Shazin · Post by **Shazin** » Mon Oct 28, 2013 2:54 pm

Hi Guys,

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

Cheers,
Shax

TM1 Forum

TM1 Query for Dimension Element

TM1 Query for Dimension Element

Re: TM1 Query for Dimension Element

Re: TM1 Query for Dimension Element

Re: TM1 Query for Dimension Element