TM1 Forum

Alan,
Can i have your attention regarding my issue?
Please help me .
Thanks

Before AND condition it was fine, i.e: Filtering Accounst and SalesMan dimension working fine {FILTER ({TM1subsetAll ([Accounts] )},(( [Accounts].[SPCode] = [SalesMan].[SPCode]) } But when adding Second Condtion i.e. Filtering with Category Dimension then it's not working. AND ([Accounts].[CatCode] ...

yes, but not working . Any idea pls.

I’m struggling with a dynamic subset and filtering on two attributes in 3 dimension at the same time. I have 3 dimension , Account, SalesMan and Category ‘Account’ has two attributes : SPCode,CatCode ‘SalesMan’ has one Attributes : SPCode ‘Category’ has one attributes : CatCode I am trying with filt...

I want to restrict data entry in 2013 , Q1 and Q2 . But 2014, Q1 and Q2 want to keep open. have two dimension “ DimYear” and “ DimQuarter” In “DimYear” two element 2013 and 2014 In “DimQuarter” four Element Q1,Q2,Q3,Q4 I tried with Element level Security in DimQuarter (Q1(R) , Q2(R) , Q3(W), Q4(W). ...

Jim
Thanks . But i am using Cube View .
Any other solution ?

My question is View related. One Accounts has two transactions . I want to show two line in views. Example : Views Showing : --------------- Dimension Dimension Dimension MeasuresDim ---------------- -------------- ---------- -------------- Account1 - Category1 - Royalty_1 - $100 - Royalty_2 - $ 300...

Thanks Martin. Due to business process - Unique Accounts Code not possible. - I am fully agree with you not to setup 'Salesman' in Accounts Dimension, Reason is with out sales man it will be 10,000 Accounts list in Dimension. After breaking by Salesman in Accounts Dimension , Now list is small. - Yo...

My problem is “Same data are showing multiple time in Cube Views” in Forecasting module. Reason is 'One Accounts belongs to multiple Sales man'. Let me explain my business Process. Business Process : We sale product to Store (we call as ‘Accounts’) across the country in 12 category. Sales Hierarchy ...

In Forecast Dimesnion, we have 4 Elements LY, Actual, Forecast and Plan. Security has been setup in Forecast Dimension as : LY = Read Actual = Read Forecast = Write Plan = Locked. But still LY and Actual is On in Views during users entering data in Forecast cell . Cell Status are showing Editable . ...

Thanks. I did the wrong not to published.

Cube view is not showing in Performance modeler. Any idea why is not showing ?
Cube developed in Architect and trying to publish in performance modeler.

Thanks. Can I copy and Paste all views in Cube ? My DRP Plan is Copy CXMD folder and Take Application Backup , if some thing goes wrong then
i will restore CXMD and Application Backup. In that case will i get back all Data and Application( Views,Security )?

Thanks Again.

We are using Cognos Express Planning Ver10. In Architect module we have one cube which in production. Now I am planning remove all element from one Dimension and upload new element in same dimension and adding one more level in dimension . We are using Forecast in Planning modules. My Question is 1)...

First of all apologizes for this kind of question (!), I am trying to connect with Contributor modules but I don’t know how to do that. I know big question is where the software installed ? but I can login Cognos Express Planner Application. My expectation was I will get contributor icon in Express ...

I have two dimension Salesman and Customer. Every salesman belongs to same customer or unique customer. Examples : SM1(Sales Man -1) -> Cust-1 , Cust-2, Cust-4 SM2 (Sales Man-2) -> CUST-1, Cust-2 and Cust-3 I need to filter on Sales man (SM1) to see only his customer information. I know it is possib...

Hi all
Thanks you guy.
Alan : When i am trying to edit the cell , messages is showing "Cell is not editable : Element "Total Year" is Consolidate. I am trying to enter in Cube View .

Thanks Again for your time

I am very new in TM1 Environment. We are using Forecast in TM1. My issues , users are not able to enter the data in Cubes view. I checked all Security in Cube level, Dimension and Element level , every where is access right is “Write” . Do I missing any thing ? Can any body help me pls ?