TM1 Forum

Hi , I have two dimensions in a cube : Dim1 -> Total -> Elem1 -> Elem2 -> ... -> Elem100 MeasureDim -> MeasureString (as string) -> Measure1 (normal decimal) I have a rule like this: ['Measure1'] = numbr( db('cube', 'Total', 'MeasureString' )); This simply "copies" the string (converted to...

Wouahh. I like this 4.94066e-324 . It seems to be exactly what I wanted although not very clean

Dear all, I use UndefVals for my cubes and I need to delete some cells' content . Not just setting the cells to 0, but really emptying the cell content, like if the cell had never got any value. I tried the ViewZeroOut but obviously, it sets 0 everywhere. Is there a way, a similar function to ViewZe...

I agree it is not difficult. It is just an open question to sense what TM1 developers have implemented in this respect.
Thx for your help!

Yes that's a good point and I will consider it. But ultimately what the business want is a "red" light indicating whether or not the data is loaded. So by creating a dedicated cube and proper rules, my idea was to give to the business a report (or Perspective spreadsheet) with a matrix wit...

Hi guys, I have a set of TM1 cubes which are loaded using TI processes. We have many data sources (> 50 csv file) which are loaded using these complex TI processes. We would like to put in place a solution to validate the data loading. The validation should consider errors in data ( empty csv files ...

Thank you very much. That's exactly what I need.

hi all, I am not sure if this forum is appropriate for my question. As I don't know the answer, don't blame me too hard! I have a data source with is TM1 for my reports in Cognos Report Studio. When doing a query in RS, I may or may not specify elements for each of the dimensions. I heard the concep...

That's exactly what I wanted!
I didn't know about this function. That's great. I have TM1 version 10.2 so the function is available!

Note that I got the same "server error" just after the installation of the FP1 of TM 10.2. After reading the release note , I noticed that I forgot to delete the config.ini file from Tomcat. After deleting this file (and a restart of TM1) the error disappeared. From the FP1 installation no...

Hi all, I suspect my problem is very generic. I have a cube which uses UNDEFVALS. It works as expected. Now, I would like to have an additional rule like ['RejectedPrct'] = 1 - ['RejectedQty'] \ ['InspectedQty']; I can see that it works for cells with valid integers (including 0) but when I get a &q...

Wouahhh it works! I have to say I understand the first "'FY' | SUBST(!TimeMonth11Months , 6, 4)" which makes sense to me. But not the second one, which matches the TimeMonth11Months dim. Your feeder doesn't address specifically the DI_FY.... elements, but all elements. Does it mean that fe...

java_to_tm1, Thanks for helping me. I have attached to this post a screenshot of both our source and target cubes. On the target cube, if I select any of the cell containing 9000, I will get the unfed status. As you can see, our rule writes the same value in all the TimeMonth11Months elements (the r...

Mmh, I try to understand your point.. not sure if I get it right. If I do a you suggested, i.e. feed from a measure which that has a non-zero value at every slice that 'Measure 1' has a non-zero value, the "check feeders" indicates that all related C-level cells are "not fed". Is...

I have a rule which "links" the data of two cubes, say S(ource) and T(arget). My question is related to the fact that we have a set of elements in the time dimension that allows storing "yearly values". I call them "direct input (DI_)". This is how it looks: DimTime: 20...

Hi All, i have a Time dimension with several nested consolidation. It is not a "perfect" hierarchical structure. It looks like Time Dimension ------------------- Current month -> 2013/03 Past 12 months -> 2013/03 -> 2013/02 -> 2013/01 ... -> 2012/04 Next FY month -> 2013/04 -> 2013/05 -> 2...

I found a possible workaround to this problem: Actually, the problem happened with IE9. I tested the application with Firefox and surprisingly it worked. Now I can say that the application "Manage rights" does not work with IE 9 or IE 10, but works fine with Firefox. I haven't tried to loo...

Hi all, I am new to TM1 and with my brand new 10.1.1 TM1, I try to manage the rights of a dummy application called "Get Bu 13 2". The application is of type "Responsability" and validates fine. It is now deployed and when I am in "My applications" web front-end, I can s...