TM1 Forum

If all leaf elements in 'zz BDE' and 'zz Broker' are identical (as you've suggested), you can substitute declanr's rule with: ['zz Underwriting Year':'Unanalysed','Net Earned Premium','zz Tenure':'Unspecified']=N: IF ( !zz BDE@=!zz Broker, DB('zz Accident Year','Actual',!zz Heads of Damage,!zz Accid...

PATCH REST API, may be???

But could potentially open up another can of worms.

Were you using the service account to run this?

Firstly, I am really interested at what is the api utility is going to do? Without an understanding of what a tm1 server is, this is going to be interesting.

Is there a default subset created for this dimension? Is it possible that you were looking at the default subset order instead of the indexed order?

What's the memory assigned to tomcat? Is there any windows log?

I think it depends on what your starting point is.

I have always used TM1SubsetAll([Dimension name]) to return a complete list of elements of the dimension, and the list is unique (ie. no dups). So, not too sure how you've build your MDX.

After I played with TM1 for a while trying to achieve my goal, I personally think TM1 is just in demo stage, not supposed to be sold as commercial product. Even with 10.2, the fact is still the same. There are too many defects in any steps (problems exist every where from top to bottom). How do you...

As a simple solution, I am wondering if grouping the combined scenario/version into years and scenarios, for example:

2015
Actual_2015
Budget_2015
Budget_FTL_ddmmyyy
Budget_FTL_ddmmyyy
Forecast_2015
Forecast_FTL_ddmmyyyy
2016
Actual_2016
Budget_2016


etc.

I think you can archive this in various ways. Depending what you want to do with that PTLCON company. Without knowing what you want to do with PTLCON, here is what I would recommend, you can add the following rule on top of your other 2 rules (and may be replace stet with whatever rule you want to a...

Is your TM1 base report an ActiveForm report?
And on the base report, do you have any or lots of conditional formatting rules?

Base on experience, with the newer version of Excel, TM1 activeforms does not handle conditional formatting well.

First, I would check if your formulas are picking up the correct dimension element references, by changing the DBRW to DBR. If values are showing with DBRs then read on... A tricky thing about activeforms is that generally requires you to include all relevant elements in your cubeview. For example, ...

Hi, If you want to apply ConsolidatedMax/ConsolidatedMin to all level 1 consolidation for the product_dim, you can use a rule like this: ['WPD' ] = C: If(Ellev('Product_Dim',!Product_Dim)=1,ConsolidatedMin(2,'',!Product__Dim, _Dim2,!Date_dim3,_Dim4,'WPD'),continue); ==> this would only apply consoli...

The parameter that indicates zero suppression is with the TM1RPTVIEW formula.

Also, can I assume when you publish to Tm1web, you have got suppress zero toggled on?

Can I assume you are trying to update a security cube using a process?

If so, select security access for your process. You can do that by right click on your process, and select "Security Access".

Hope it helps.

Hi, You may want to give this a try: 1. Insert another cell/element in your cube (Cube A), eg. running 2. At the start of your master process, insert code that adds a flag in this new cell, eg, Y. 3. At the end of your master process, insert code that removes this flag. 4. In your control cube (Cube...

TI wouldn't give out any error message, since the command executed is a correct syntax vbs command. I would suggest test out the command from a command line, run cmd, and enter >D:\Mail\SendMailOther.vbs with parameters between double-quotes. If there's anything wrong with the vbs, you will get an e...