TM1 Forum

Peter, Can you tell me how to add Subscriptions here?

Thanks

I am wodering if I can change the sign of Negative numbers using the 'TM1 Display Format' as shown here: http://publib.boulder.ibm.com/infocenter/ctm1/v9r4m1/topic/com.ibm.swg.im.cognos.tm1_ug.9.4.1.doc/tm1_ug_id10861NumericValues_N701AF.html#NumericValues_N701AF or by using 'Display Format Attribut...

Matgoff, can you please explain what do you mean by:

Wrap your DBRWs in SUM()

I think Alan's option 3 can be adopted. Anyone else, please let me know if you have some other solution.

I am aware of DBR and DBRW formulas by which you can both Read and Write data (2 way) into the cubes. Is there a Formula in TM1 by which you can only Read the data from the cubes (1 way) and can not update/change the cube data from the spreadsheet. Please let me know if such Spreadsheet formula exis...

Can you please explain your methodology? A sample rule will help.

If we can convert the sign using the Attribiute Formatting then it will be a lot easier, but not sure how can we do it.

Hi, I need some advice to change the Negative numbers to Positive. My data has got the Expense and Revenue numbers. All the Revenue numbers have Negative sign in the backend database and I want to see these numbers without the Negative sign in the TM1. What will be the best practice to do this? Shal...

I have recreated the dimension by concatenating the Column names e.g. for SubDept it is now Dept.SubDept and for DeptFunc it is now Dept.SubDept.DeptFunc There are some DeptFunc codes which are found under multiple SubDept, and because of that the hierarchies/Alias are not built-up correctly. See th...

I am trying to build a dimension based on the sample data in the XLS file which is attached here. The dimension hierarchy should roll-up like this: Dept -> SubDept -> DeptFunc and the Description should be the Alias The problem is that in order to define the hierarchy in the database in the source d...

You mean I need to run the Workflow Setup again for the each DB I am using? Does that mean that I can use Workflow for only one TM1 server/DB at a time?

Please confirm

I am new to Workflow and I need to ask a very basic question about it. TM1 manual is not very helpful. I am not sure whats the starting point to create a Workflow. I can not access the Workflow Admin Console when I am connected to my database. It gives me error: "planning sample No TM1 database...

I have question regarding the Performance Monitor. All performance monitoring control cubes use the }Time Intervals control dimension. My understanding says that this dimension only stores data for only past 24 hours. After that it starts overwriting the values. Does this means that we can not monit...

I want to update the value to my Element Alias using TI or Worksheet.

Is there any Tm1 function which I can use?

Please reply ASAP

Thanks in advance

Thanks, it works with Mozilla Firefox 3.5.

But the 90% of the clients have IE on their computers therefore I am really interested to know whats wrong with IE and how to fix it.

Any ideas???

Hi, I have installed TM1 Contributor 9.5 over Apache Tomcat. I have created a Test Contributor application by defining Views, Approval Hierarchy and have set up the Rights already. But I am having problem in starting the TM1 Contributor application. When I click on the Approval Hierarchy link it ope...

I have got that working and now getting the Distinct Counts within the rule (without using any lookup cube). SKIPCHECK; ['All Customers','Count'] = ConsolidateChildren('Customer'); ['Count']=IF((['Sales'])>0 & ELLEV('Customer',!Customer)=0,1,STET); FEEDERS; ['Sales' ]=> ['Count']; Thanks everyon...

Your proposed solution is giving me the COUNT...but I want DISTINCT COUNT for the Customer. I want to see how many DISTINCT customer has done transactions i.e if a customer has made multiple transactions my Count should only show 1. I have added the following rule which gives me the correct DISTINCT...

Steve the suggested rule gives me the Count of the Transactions. I actually want to see the DISTINCT Count . I want the rule to set Count=1 IF there are 1 or more than one Transactions. Both Count and Sales are in Measures dimension. Please advice the solution. Your prompt reply will be highly appre...

I have many dimensions in my cube like Customer, Region, Products, Period, Measures etc. I want to get the count of the customers who have bought a certain product. I have added a measure 'Count' and have added this rule ['Count']=N:IF(['Sales']>0,1,STET); where 'Sales' is a measure. This gives me t...

I actually want to load the data on monthly basis, that is why I don't want to add multiple CellPutN() in my Data tab.

Is there any other suggestion or something which I can do using the Parameters?

My ODBC data contains data in different columns e.g: Jan_Sales Feb_Sales Mar_Sales 100 500 650 I want to pass the DB Field name as a Parameter in my TI Process so that I don't have to write many processes for each month or to run the same process by making changes in each time. Can I create a parame...