TM1 Forum

Hi,

I did not post the above comment into this post yesterday! I am pretty sure I posted this back in December!

Is there a TM1forum forum!

cheers, Mark

Hopefully vino will put us out of our misery and tell us the logic behind this! I saw something like this once where within TM1 there was a need to reconcile 2 different TM1 models because data was transferred between the 2 models and for whatever reason the organisations chart of accounts looked di...

I know, as am sure lots of us do, that you can easily make charts dynamic in Excel by converting the data into a table but what I hadn't thought of was converting data in TM1 active forms into tables (I think I must have subconsciously thought it wouldn't work in the web!). But actually it does work...

Hi, I didn't really understand your issue (though I am sure your English is a million times better than my German!). But you did ask a specific question, How to get rid of the zero value dynamically. In Active forms you can switch zero suppress on or off via the TM1RPTVIEW formula. The second argume...

Hi Watch the start of this video (https://www.youtube.com/watch?v=pxjnKz9-h7M) for the general idea of putting the button below the image (though in this case they use hyperlinks but it can easily be done with action buttons). If your button no longer works try deleting and recreating it For option ...

Hi, We are still on 10.1 and I have found images on action buttons to be problematical, particularly when trying what you are doing. So I have 2 alternative ways to deal with this Option 1 - embed the image on the actual worksheet (not on the action button) and put an action button underneath the im...

Hi, Unless you have a million and one groups not sure why adding a simple if statement to the websheet wouldn't be the easiest way of doing this? And the colour format references the cell where the if statement is. Lots of other ways to do this but another relatively simple alternative: create an at...

I had an issue in the past and the reason for the unable to listen on port error in my case was that I had an action button in a worksheet (a simple recalculate) that pointed to a different TM1 server. Once I updated the action button to point to the correct server the issue was resolved. cheers, Mark

Ok thanks Wim

Hi, Am looking at making a TM1 model (which calculates housing rents) a little more efficient, just looking at the rules it raised my curiosity which is the best way to write a rule, Option 1 ['Formula Rent Calc A']=N: if(NUMBR(SUBST(!Year,1,4)) > NUMBR(SUBST(!UH_Versions,1,4)), DB('UH_Current_Year_...

Yeah I like FormatDate and ParseDate, just wish I had known about them before now!

Are there any other functions like these that are lurking in a darkened corner or have I missed something in the documentation?

I was thinking along the same lines as Okamasu, create a new cube using TI and populate, so Cube A is the source view with skip zero and you cellget the budget amount for each period from Cube B, then report off the new cube or No new cubes and on the websheet make the active form look at Cube A and...

Hi all, just noticed that babytiger has pretty much answered my question in this thread! See here http://www.tm1forum.com/viewtopic.php?f=3&t=14251 For example I used the following to return the years greater than the Current year in the admin cube and less than 2040 (I am still struggling to allow ...

If these tax rates change frequently or you want to model over versions, over years and the tax rates could differ over time etc, then an alternative would be to add an attribute called type to the product dimension, so each element is either car, van, plane etc and hold the tax rates in a tax rate ...

Hi Jim,

Really appreciate the response, thanks.

There are already TI processes that re-compile the feeders via CubeProcessFeeders, so I think that issue is covered Also the servers are shut down and restarted once a week.

cheers, Mark

Hi all, I have a task to make a model more dynamic, as there are literal values in some rules. For example how far the rules project into the future years is a literal value of 4. So an example of a current rule and feeder is as follows Rule: ['AppHrs'] = N: DB(If(Numbr(!Year) > DB('Admin_Cube', 'Ge...

I wondered if there would be something simpler than this, but I would have followed Tom by doing a CubesaveData on the cube in question and then running a batch script within a TI process to get the last modified date, so a command like: wmic datafile where Name="FilePath\\FileName.cub" get LastModi...

Hi, I feel your pain, if I had to update all my websheets and dimension builds due to a bug I would be annoyed! I have an upgrade from 10.1 to PA on the distant horizon and expecting issues like this! Re the workaround, you could call the Dummy element in the dimension something like No Data Availab...

Hi,

glad it worked, though when you think about it it isn't that amazing because without the = sign excel would not treat it as a formula and instead treat it as a string value.

cheers, Mark

Hi,

I presume the actual formula in cell B82 is not

{DRILLDOWNLEVEL({[student dimension].["&$B$65&"]}, ALL, RECURSIVE)}

But is actually

=“{DRILLDOWNLEVEL({[student dimension].["&$B$65&"]}, ALL, RECURSIVE)}”

cheers, Mark