TM1 Forum

Folks, figured it out. The space issue wasnt before the 0 in 0 Level, there was a space betwwen server: and dimname.
Problem solved.

Nope. Dimension name has no space.

Hello, I have a cell (D22) with a SUBNM formula. I use that cell to create a subset in view TM1RPTROW($C$12,"srv:dimname",$D$22 & " 0 Level"). This works well in the spreadsheet but in TM1 web, when I double click D22, it says it cannot find the dimension. Is there something ...

thanks!

So if i put ExecuteProcess('Loading') after the process break,will that work?

Hello,
I am trying to read the first line of my ascii datasource to pick out parameters to zero out the cube. It's easily done in ODBC Connection where I use Select top 1 from dbo.datasource. How can I do similar for an ascii datasource ?

Hello,
Will IF(OR(condition1,condition2),true,false) or IF(OR(condition1,condition2),true,false) work in rules?

Hello, I have built a dimension with a TI process. It has 'Total Customers' as the Consolidated name. When 'Total Customers' is used in a view, it does not seem to add the data of the new customers added until I double click the Dimension and click "ALL".Then the new customers appear. Is t...

Well I have created that directory. So are the rest of the changes ok?

which is safe to conclude then that I dont have a local server. So do I change the following details in my cfg file? my input is between the ** [TM1S] ServerName=*mycomputername* DataBaseDirectory=*C:\Tm1Local* loggingdirectory=*C:\TM1Local\Logging* AdminHost=*mycomputername* ServicePrincipalName=HT...

Well i seem to get it working by copy the Client Properties cube onto my C Drive from Production.
But there is a problem with the log files-It says "Error opening the log file"...what should I do?

Hello,
I am having problems starting the local server. I have copied 2 files Data and Worksheets in C:\TM1Local.
Q1. Should the data dictionary be C:\TM1Local ? or C:\TM1Local\Data or C:\TM1Local\Worksheets?
Q2. I am getting Client's password is invalid when we have integrated login.

Can anyone help?

Thanks.
So with the split, it means that the zero out will be in 1 TI and the data loading in a separate TI right?

Hello, I have the code snippet below in Prolog. I have a text file as datasource with Period_Name, Account, Project, Amount in the Variables tab. I have tried to use the Period_Name from the Variables tab but it doesnt seem to work.I get a "Dimension Element not found" at SubsetElementInse...

Hello, I remember reading somewhere on this forum that it is better to build dimensions before loading the cube and not as we are loading the cube. Is this the common understanding or did I remember incorrectly? Would the situation be different if the source of your dimension (text file) is the same...

I got that error when I double clicked the Cube that has that Measures dimension
BUT, double clicking another cube that has the same dimension does not give me that error message.

Hello,
I have admin rights but I am getting this error message "Measures: No read access to elements, cannot view". Measures being a dimension.
What have I done wrong?

Hello,
I seem to get an error message for my TI when I CellGetN of a consolidated cell. I want to get the value from the Balance, a C level element and put it into n level element. What am I doing wrong?

I want to put a flag=1 for the following accounts and companies.

What feeder should I put ?

['Flag']=N:IF(ELISANC('account','X000000',!account)<>0,IF(ELISANC('company','AUS',!company)<>0,1,0),0);

Thanking you in advance

I do not want to use view create because it will create an empty view and i would have to have lines of codes to add the dimensions.I am trying to avoid building a view from scratch when I already have and want to use a pre-created view.