TM1 Forum

Thanks a lot Alan and qml for your replies...that solves my problem..!!!

Hi, I've a requirement to club a few stores in the location/geography dimension and to find the sum of the sales figure. Though we've defined an flag attribute (Y/N), i presume we can only use the attribute to create a subset of stores which have the attribute as 'Y' or 'N' - and not create a consol...

Hi All,
Can somebody give me a few ideas/inbuilt mechanisms in TM1 which help you do What-If analysis?

I'm completely clueless about What-If analysis and thats why such a vague question. Sorry about it.

Regards,
Deepu.

Thanks. But, I'm struggling to find out how to set 'admin' access to user groups? We have a user group called 'Planners' containing the names of all the Users (Planner role) maintained in the 'Clients/Groups' grid. Yes, Users need to be given access to upload the data as they are responsible to inpu...

Thanks, But unfortunately it doesn't let me 'type' anything on the grid cells. Instead I can copy-paste contents from elsewhere into the grid cell. I am also unable to copy-paste anything other than 'None' or 'Read' - probably since these are the only two options which is NOT greyed out. It simply d...

Thanks for your response, Marcus.
But, we also need to provide our users 'write' access on specific TI processes that are relevant to their areas.
How/Can we provide this access to the relevant user groups?

Regards,
Deepu.

Hi All, How do I give an user the access to run one specific TI process without adding the user to the "Admin" group? He/she belongs to "Planner" group..When I click on the "security assignments" option for Processes, I can see only "None" and "Read"...

Hi All, We've a problem in our TM1 system...We've a few cubes with data which hold day-level data. When we write a rule/feeders in these cubes with day-level data and save, it takes a huge amount of time (say more than 1 hr), the screen grays out and we don't know whether something is being processe...

Thanks for your reply Lotsaram...But the environments are indeed the same at least in terms of the rules and the cube properties. Also I deleted all the rules from the cube, saved the rules (after blanking out), and then recalculated the cube. Then i tried the same spread but I'm getting hte same er...

Hi All, We're facing a strange issue in the Prod environment. We'd moved all the cubes and the pdata files from the UAT environment to the Production environment last week. So now we have both - UAT & Prod - the environments up and running . I'm not able to spread data (Relative proportional/Equ...

The first time round, if a hold has never been applied on a cube, how would the control cube '}Hold_UserName_CubeName' be created.
TI throws an error as 'Cube not found' while trying to write 'H' into the control cube.

Thanks,
Deepu.

Many Thanks Rizwan - Certainly helpful!

Just wondering how/when does this Control cube get deleted?

Regards,
Deepu

Hi All,
We need to do Hold Consolidate and Hold Release in TI processes.

Please pour in your suggestions.

TM1 - version 9.5
Excel - 2003

Regards,
Deepu.

Folks,
Thanks for your replies..
The total size of our data directory is only 5 GB. Why is that the admin server needs so much space? Our total RAM size is 20 GB.

Regards,
Deepu.

Hi All, Our TM1 application is very slow in loading up. Also when 2 users open cubes simultaneously, they end up with "hanged" sessions. One more issue is that when TI processes run, the cube starts responding slow. I noticed something - the tm1sd.exe is holding up 19 GB of memory when the...

Hi Guys, I need an urgent help on this. Problem statement: I need to write data from the cube to the Access DB. Note:My DSN is called POC.mdb, my database is Access_DB. Actuals is a number column. I just select ACtuals from the cube and load it into the Access DB. TI Process that I've created: Prolo...

Hi All,
I need to connect to an UNIX based server which hosts the scripts that load data into the data mart. My TM1 jobs have a dependency on the ETL jobs which load data into the Data mart.

How do I define TM1 dependency on an UNIX based server?

Pls help..


Regards,
Deepu.

Hi All, I've an issue with Relative proportional spread - here are my dimensions Period: DIM_PERIOD -FY2010/11 Relative Proportional Spread issue.doc -- FY2010-P01 -- FY2010-P02 ............ -- FY2010-P12 Expense lines: DIM_EXP --Total Exp --- E1 --- E2 --- E3 --------E31 --------E32 --------E33 ---...

Hi Lotsram,
Thanks for your reply..can you elaborate a bit more, on the store lookup part?

Regards,
Deepu.

But how do we ensure that the comparison of an old store is appropriately done as mentioned in my earlier post? Ex: Store opening date - 15 March 2009 Transition from Old store to new store - 15 March 2010 LY sales Vs TY sales at the end of March - (Sales of the store from 15 March 2010 till 31 Marc...