TM1 Forum

Hello Duncan,

Even I have the same views. I also dont see a way of inserting a blank element through dimension picklist.

But even I will be happy to prove wrong.

Thanks

Hello Friends, I wanted a suggestion. I was working with String Picklist. I preferred a dimension based Picklist, so that whenever there is an update made to the dimension, it gets updated in the Picklist. Can we De-select a cell if the picklist is dimension based? What I want to ask is, when we cre...

Hello Friends, I am exploring the TM1 10.1 Utility TM1Xfer for one of our requirements. I have a few questions regarding that, if anyone can help. 1) Can it only transfer directories from one platform to other and not individual files? 2) Does it creates the same directory in the destination locatio...

Hi, It may look a pretty naive question. But since we are moving to TM1 10.1 from TM1952, I want to ask a pretty basic question. What is the use of TM1 Architect, when the document says that Cognos Insight (TM1 10.1) is able to do data loads as well. Is it just that Cognos Insight is a good looking ...

Thanks for the informatin Alan. But I think I should try reinstalling the XP Mode onto my Win7 machine as it is not working out for me (may be because of compatibility issues). I have though successfully installed this version of TM1 onto Win XP (When I was using XP Earlier), but not sure why this i...

Has anybody got any suggestions to offer on the above mentiones issue......

The CMD is running on Windows XP. As I said I have installed a virtual machine (Virtual PC XP Mode) on my windows 7 machine, from the below link

http://www.microsoft.com/windows/virtua ... nload.aspx

So I guess in XP it not required to run as administrator.

Hello Friends, I am facing an issue with installing an Instance as a service. I am using a Windows 7 Machine and installed Windows XP mode over it to work with a TM1 9.5 Now when I am trying to create a service for this instance, it is not giving any error, but not creating the instance as well. It ...

Thanks Alan.

That really did help.

Well Alan, Thanks for a superb and very clear explaination. I would rather say, this is much more clear than given in the User Guide. 8-) To conclude I want to get 1 thing right in my head. As you shown in the example, that if there are 2 row dimensions, the value in column A is picked up checking c...

Thanks Alan, I checked and as you said TM1RPTROW has a worksheet with name {AR}01. In case of subsets it becomes obvious as to how the Format Definition is applied in the Column A (Like 0, 1, N ). But if the values are handpicked, in that case does TM1 do a relative assigning of these values in colu...

Hi, I have a query on Active forms. TM1 User guide says, Column A in Avtive form has a value that contains format definition corresponding to level of each subset element. I want to ask, what if the row dimension does not have any specified subset in the view. I mean in my case, in the row dimension...

As many of the folks has said. Such error is encountered when there is an issue with the SQL (Otherwise the error would have been on some other line of Prolog). If the parameters are not used in SQL, then I would suggest you to test your connection and see if the username and password are still func...

Well, as per my understanding, every single row gets processed by metadata and then by data tab and then the second row is picked up, which follows the same path. Have you read it somewhere on IBM site about execution of records like this? If so, please let me know I will test my data as per what yo...

Hello, I have a question regarding the use of ItemSkip. I am using Itemskip in metadata tab. The Criteria is such that in the metadata tab, this is the code If (DIMIX('Customer', vCustomer)=0); ItemSkip; EndIf; In the data tab, I am using a cellputN function. But I am getting an error which says, th...

Hi asutcliffe,

Thanks for the suggestion. It was a small error which got rectified. Actually I was going through one of the other reputed TM1 forum and someone there suggested to use ~ and <>= operators.

Thanks for the help anyways.

Hi Friends, I am facing an issue. I am retrieving a value using CELLGETN function and assigning it to a variable as shown below. nRevAdjPctVal = CellgetN (sCube, V10, V1, 'REV ADJ PCT', 'LoadStat-All', 'BP-All', 'BOXMES-All', 'FOP-All', 'Sector-All', 'AP-All', V8, 'data'); Now when I am comparing th...

Hi,

Thanks for the reply. Yes, I did post a similar question there, as I later realized that this is a better thread to get this question answered.

@Alan, Thanks for the information below. But I have a question. We are saying that an "!Year" refers to all the elements in the year dimension. Then How does TM1 parse the cube cells which has rules applied to them. I mean to say, just as Turbo integrator parses the data row by row. How do...

Hello All, I require a small help on TM1 Rules. I am new in writing the rules. We have a rule that checks this condition ELISANC('region','AP',!region)=1) I saw that Elisanc checks if first element is ancestor of 2nd. But I dont know what the "!region" means. What does this Exclaimation ma...