TM1 Forum

The strange thing is that I can see this cube from Architect but not from the Performance modeler, thats why I am wondering if this is system cube

Hi, In my server there is a cube which its name is consisted from the "_BAK_" and a name of a other cube that we have Budget_Sales. _BAK_Budget_Sales. When the server starts I saw that there are some lines that say adding cube dependency. 3600 [] INFO 2016-06-22 06:59:52.699 TM1.Cube.Depen...

Having used PM much for these things but it has a prolog tab so just use your parameter/s to build up a string which is your SQL query and then use the datasourcequery function to set it there. Leave the actual data source tab to just be the full SQL query and it will be fine. Finally is what I do,...

Hi Trevor, I try the following sql SELECT [Name] ,[Year] FROM [Test].[dbo].[Table_1] where [Name] > CAST('10' as int) and the process execute. Create a parameter pName with type Text I change the above sql as SELECT [Name] ,[Year] FROM [ELBISCO].[dbo].[Table_1] where [Name] > CAST('?pName?' as int) ...

I am trying to create a import process with not much success. In Architect in turobintegrator I was able to create a process in which the sql query received parameter and the process was executed. For example select * from lib.table where name = '?p0? and 'when the process was executed the user was ...

Theoretically speaking the port 5495 and 5498 are open.

How can I check which ports are open and which ports the TM1 uses?

Yes I have already try that with all possible combinations server name, full computer name, ip
but with no result

I have installed TM1 ( all components in one server) and TM1 Web in another.

When I open the link of TM1 Web I can not connect to the admin host and no servers are in dropdwon list.

Does anyone know what I have to check or change in order the TM1 Web to work?

Firstly thanks a lot for your feedback To be honest is what I thought to do ( regarding the rule) What about the feeders? Should I place feeders and on the cube2? I came into this solution as I have a number and the user habe to define if it is sold or not for month. Imagine that there more 3 diment...

Hi Experts, What I am asking maybe is a common thing to TM1 but since I am a newbie I will help your assistance I have a cube with two dimensions lets say Months Products and another cube with three dimentions Month Products Sold (which has two elements yes/no) I want to move the data of the first c...

Thank for you replies.

I can fully understand that it is not the best practise to create a rank using a rule.

But my quenstion remains. If there is a more sophisticated way to right this rule.

Unfortunately TI process is not an option in my case.

What other information do you need to provide you in order to give me some extra tips?

gdimit, I'm pretty interested what purpose you would put this to? I've never been in a position to need to know the difference between 0 or null or to know if a cell is null or not. What would the practical application of doing what you want? Cheers, What I want to store is football results. So in ...

Hi Wim,

I admit to be a bit lazy to reply but I have made only 3 posts including this one.

Now that I am replying do you have any suggestion?

Thanks in advance

Hi all, I want to create a measure that rank the members of a dimention based on a measure. What I came so far is to create a measure for its member in which I compare the value of the member against the value of a another member. Finally I added the new measures. For example lets assume that I have...

I want to write a rule that checks if the cell is null or not.

My problem is that either the cell is null or 0 I have the same result.

Ideally I would like the calculation not to be performed if the cell is null and to be performed if the cell has 0.

Any recommendations?

Hi all, I have a column that its name contains a special character for example Product? (the name of the column contains the quenstion mark) when I wrote in TM1 process SELECT [Product?] FROM [GOSALES].[dbo].[Special Characters Test] I get the error "SQL Statement Failed" when I wrote SELE...