TM1 Forum

I've tried to write a rule with feeders on my cube. But After creating feeders the calculation by hierarchies dont work. Can u help me write feeders for the next rules. SKIPCHECK; ['AccountFAInput':'111','MeasureFA':'100','FixedAssetsInput_Months':'10']=S: DB('InvestProject_Parameters',!Branches,'01...

I have the same error but with small differences.

There're 3 excel files, Import is ok from the first and second files but import don't work from the third file.
Can u help me?

There are #N/A in quaterly total.
Why?

Can u help me? There are calculations: ['090100']=N:STET; C:(['090100','11']*['090092','11' ] +['090100','12']*['090092','12'])\['090092','10']; ['090101']=N:STET; C:(['090092','11']*['090101','11']+['090092','12']*['090101','12'])\['090092','10']; ['090102']=N:STET; C: ['090104']\['090092']; How wr...

I found an error.

There're data in the last cell, but in the first cell not data.
What is command for searching data in the whole cube? Now TI search data only in the first cell...

I have data in my datasource.

#****Begin: Generated Statements*** #****End: Generated Statements**** vName=cellgets('Templates_DIBP', Филиалы, ФинСтруктура, Время_Годы, Тип_производства, Templates_Статьи, '010'); textoutput('c:\3.txt',vName); This is don't work. If i type in metad...

I need help!

TextOutput work in Prolog tab, but don't work in Metadata tab.

Can you help me...

I need help!

How i can hide elements in the cube which depends on values into cells in this cube?

David Usherwood wrote:Create and populate an attribute to link the quarter back to the first month.
Depending on your naming convention you may be able to write a rule in the attribute cube to to the link automatically.

Can you give me construction of this expression?

Hi! Cube consist of two dimensions: balance and time. Time has hierarchy:Year 1->Q->Months...Year n->Q->Months For the 1 item of balance for the all Quarterly values instead of Consolidation(summation) i'll take first months of quarter. I have 10 years with quarter and months. How i can calculate th...

I create TI process. Result of TI process is number.I put number to TI Variable. Can I connect through Perspectives for Excel to this variable(to Result of TI process) and show this Variable in Excel? Many sites have a cube which is used to control the execution of TI processes or chores. Those cub...

TM1 Guru, I need help!

I create TI process. Result of TI process is number.I put number to TI Variable.
Can I connect through Perspectives for Excel to this variable(to Result of TI process) and show this Variable in Excel?

Thanks in advance:)