TM1 Forum

Thanks Mark. It is same name (Employee) for dimension and cube , created a new cube , works fine now.

Thanks again!

Mark: Extra ")" was a typo. I don't see employee list filtered from this MDX. DRG: Intent with TM1subsetall on Employee dimension is to include all N-level employees. In the attached, I should see E3 filtered as a result. Also replaced Version with Version-Scenario as is defined in my model.

Hi, Appreciate any help on the following. Cube 1: CostCenterSelection Dimensions: Cost Center, Version, Measures (SelectCC as string with value Yes/No) MDX to filter Cost Centers that have "SelectCC" measure value "Yes": FILTER(TM1FILTERBYLEVEL( TM1SUBSETALL( [Cost Center] ), 0),...

Thanks! This worked , also I added another requirement which worked as well. Here pick only valid employees for that cost center by resolving all cost centers. For each Cost Center read , check if Emp is valid an Home Country is Germany. Thanks again!!! { INTERSECT ( GENERATE(TM1SUBSETTOSET([Cost Ce...

Hi, I have a 4 dimension cube Employee: Cost Center Version Employee Measures. In an Active Form, using the following MDX expresssion, when I filter Employees on any measure in Employee cube by specifying value from each dimension, query displays correct employee count and names. For e.g. FILTER({TM...

I'm getting prompted to log in twice fro every data refresh. Have subnm on CAFE Flex view report. Running CAFE 10.2.2, build 10.2.5200.160.

Can't seem to find an resolution for this.

Also manually re-ordered dimension and found optimal order resulting in Version dim as last one.

Thanks Steve! Unfortunately can't run TI's in Parallel as have just 2 CPUS available on this server. Tested the following today: 1. Ran TI with no code in DATA tab, completed right away, no surprises there. 2. Ran TI to write to CSV, same behavior. 11 GB consumption. 3. Ran TI to not update any cube...

Hi, I'm sourcing a SQL Server table to load data from with 6 columns. TI has no metadata updates within. Cube has 6 dimensions. No rules defined. Last dimension is version dimension with 2 elements. Server consumes 11 GB RAM to load 7.5 million rows. Once process finishes, restarting the server show...

Obviously user error on my art. Apologies. Pressed Build Active Form and works like a charm.

Thanks a lot!!

615700 account has 2 Cost Centers as shown above, per expression.

Switching to 615800 should show cost center 400282 but is not getting refreshed.

Hi EvgenyT, Expression is set to ="{FILTER({TM1FILTERBYLEVEL( {TM1SUBSETALL( [bcbs_Cost Center] )}, 0)},[bcbs_OpEx].([bcbs_Account].[" & C11 & "],[bcbs_Methodology].[Budget],[bcbs_Month].[12YTD]) > 0 )}" This gets resolved as: {FILTER({TM1FILTERBYLEVEL( {TM1SUBSETALL( [bc...

Hi, I'm trying to dynamically update row subset based of a value selected in title element. Planning Sample:bcbs_OpEx:15 {FILTER({TM1FILTERBYLEVEL( {TM1SUBSETALL( [bcbs_Cost Center] )}, 0)},[bcbs_OpEx].([bcbs_Account].[615800],[bcbs_Methodology].[Budget],[bcbs_Month].[12YTD]) > 0 )} bcbs_Account 615...

Resolved.

Just insert the right hand side of the rule and exclude area definition.

Hi, My first attempt to use Insight here. Got through loading fact and building dimensions using fact SQL successfully. Trying to add Custom calculation by right clicking on a column->Calculate->Custom to add the following: IF (DB(..) > 2, 'HIGH', 'LOW'); Errors out. Is this possible using Custom Ca...

Hi, I'm not able to get pass the following error while trying to deploy Approval type application: "An unexpected error was generated by a TI process". This is brand new TM1 instance with 1 cube, using TM1 native security. Have tried: 1. Stopping TM1 Admin Server service, delete pmpsvc fol...

Hi,

I'm trying to add multiple views from different/same cube(s) to same worksheet. Any examples on this would be very helpful.

Appreciate your help and thanks in advance.

Hi guys, Was wondering if anyone has used I_PROCESS TM1 macro function in VBA ?? I have created active slice of the cube view and would like to display a message related to functionality on this slice. For e.g. If Add vendor TI failed, I would like display the exact reason. For this I write error me...

I would change to domain account to run the TM1 Excel service if that's not the case, restart this service.

Also 9.4 MR1 requires .NET 3.0 framework installed. Within IIS, change the default ASP.NET version to 2.0. Restart IIS .

Hi guys, I have installed TM1 9.4 MR1 5088 build on a X-64 Windows VM env. Using ETLDAP tool was able to port Active Directory users to TM1. LDAP authentication works in TM1. Integrated login fails with SPN error. Confirmed USERNAME@REALM is populated in UniqueID field of Clientroperties cube, still...