TM1 Forum

sorry to hijack the thread..but is it possible that i follow the steps in the prezi for version 9.5.2?
Looking to overcome the applix cert expiring on 24th Nov 2016 issue..

ioscat wrote:Possibly yes and possibly no
Depends on

depends on what?
It really is annoying to get something like this with only 2 decimal point involve: look at all the (0.00)...

Alan, thanks for the reference.
So i guess it is impossible to stop the view from calculating upon opening it...

I always wanted to ask this question:
Does setting up a testing environment requires an additional server license?

I am talking about Cube Viewer.
When i save with the option on, it works as intended, meaning the values are automatically fetched when the view is opened.
When i save with the option off, the values are also automatically fetched when the view is opened.
I wonder why.

I am on 9.5.2 FP1 now.

I find that if i save a view with automatic recalculate turn on, then try to save it with automatic recalculate turn off, it doesn't work.
Is it a bug? Or is as intended?

So in summary, it is not possible to get a zero, unless using the "safe divide" method in the rule itself?

okay, so this is what i understood:
1. Alan is trying to explain, that we can round values using weightings instead of applying rounding method directly in rules.
2. There is no direct way to use natural consolidation to do a division.

I am also facing the same problem. Sometimes, the rule must be evaluated, but sometimes it should be STET. But regardless of whether there is a rule applied, i still want to ViewZeroOut that particular area of data. Since we cannot specify any options in the ViewZeroOut method, i am still wondering ...

i am lost

Whats wrong with TM1 displaying values like (0,000000000000)? I have a natural consolidation [CD Amt], calculated using [Std Amt] - [Act Amt]. By calculating it manually, i get a value of 0. But the natural consolidation gives a (0,0000000000) value as shown in the attachment. I have checked that th...

ok understood, thanks for the feedback.

Is it possible to use natural consolidation to calculate %, such as:
A amount / B amount = AB%

AB%
|_ A amount
|_ B amount

Status of the cube before process run is "Lock".
I didnt know about the CubeLockOverride function, this is exactly what i needed.
Tested and worked.
Thanks lotsaram.

what if the sub process would would CellPutS into the }CubeProperties cube?
Basically i am trying to lock a cube after finishing the whole process.
Is it doable?

Hi, I have a end user process which calls a sub process. Inside the sub process, there is a CellPutS code. When end user runs the process, the sub process CellPutS code does not execute. But if i run it as admin, the code works. Question is, how can i overcome this without setting end user as admin?

yep i tried with all possible year/month combination, it works.

i guess i did not mention that year dimension and month dimension is actually in the title of the view, does it make sense now?

just did the test, it works.
previously it didnt work because my attribute type is Text.
created another attribute with type numeric and use the same MDX statement, result: its working.

Do you think it is possible for this to work? {FILTER( {TM1SubsetAll( [cdwPeriod] )}, [cdwPeriod].[Fiscal Year] = ([cdwYear].[Fiscal Year] - [cdwMonth].[PriorYearComponent]))} Selected Year = 2013 Selected Month = Feb Fiscal Year Attribute for 2013 = 2013 PriorYearComponent Attribute for Feb = 1 So ...

I have 3 dimensions, year (2012, 2013), month (01, 02, 03, 04) and period (201303, 201304). I am trying to create a dynamic subset on period such that when user selects Year and Month, it will retrieve the respective periods for that fiscal year. Fiscal period begins from April to next year March (F...