TM1 Forum

Thanks you. You mean we have 2 Methods like these ? 1. Create Consolidation Node and Add ACCOUNT to that node 2. Create Rule like [ 'IC_PL_OTHERS' ..] = N: [ '510000' ... ] + ['512000' ...]. I can't using subset in rule It is perfectly alright to use subsets in rules,Please go below links: http://ww...

Dear All How to using group of element in rules / subset in rules. I would like to create rule like this. ['G_NONE', 'THB', 'AUD21101 IC ELIM', 'IC_PL_OTHERS' ] = N: DB('CONSOLIDATION', ' ACCOUNT':{'51010000','51020000'} , !ENTITY, !FLOW, !INTERCO, !RPTCURRENCY, !SCOPE, !TIME, !VERSION, !MEASURES); ...

Sorry I get solution. Thanks
[ 'F000 Opening Balance' ,'2014.01' ] = N: IF(ATTRS('ACCOUNT', !ACCOUNT, 'ACC_TYPE') @= 'BS' , ['F999 Closing Balance', ' 2013.12' ] , STET);

Hi All
I'm new for TM1. How to scope result area dynamically?

[RESULT AREA] = N: [SOURCE]

I try to create rule for balance carry forward. It should be perform only Balance Sheet GL Account. How can I do it in TM1?

Thanks in advanced

Thanks everybody.

Thanks all of you. My user has ADMIN role. If I change to user define role, it work properly.

Experts I need your help. I create Cell Security Control Cube via context menu on target cube. After that create rule on control cube to set 'READ'. But in target cube cell can be write.
What I am wrong? I run TM1 9.5.2 on local machine.

Hi
I use SSRS with OLE DB driver for TM1 but u need to create MDX manual because query designer doesn't work for TM1 data sources. Good luck