Search found 170 matches

by Mark RMBC
Fri Feb 22, 2019 9:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to import a CSV file to a cube with two extra dimensions
Replies: 5
Views: 820

Re: How to import a CSV file to a cube with two extra dimensions

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
by Mark RMBC
Thu Feb 21, 2019 5:18 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to import a CSV file to a cube with two extra dimensions
Replies: 5
Views: 820

Re: How to import a CSV file to a cube with two extra dimensions

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...
by Mark RMBC
Mon Feb 18, 2019 10:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 3 simple steps to Active form and chart harmony
Replies: 4
Views: 154

Re: 3 simple steps to Active form and chart harmony

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...
by Mark RMBC
Wed Feb 13, 2019 11:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Active Report in TM1web
Replies: 6
Views: 151

Re: Active Report in TM1web

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...
by Mark RMBC
Thu Jan 10, 2019 10:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action button: eliminate borders
Replies: 7
Views: 293

Re: Action button: eliminate borders

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 ...
by Mark RMBC
Wed Jan 09, 2019 10:16 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Action button: eliminate borders
Replies: 7
Views: 293

Re: Action button: eliminate borders

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...
by Mark RMBC
Mon Nov 19, 2018 1:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Websheet function: find the Group of a user
Replies: 7
Views: 1588

Re: Websheet function: find the Group of a user

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...
by Mark RMBC
Thu Oct 25, 2018 10:07 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to change port numbers in tm1
Replies: 6
Views: 394

Re: How to change port numbers in tm1

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
by Mark RMBC
Fri Oct 19, 2018 2:21 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 rule using DB IF and Stet
Replies: 3
Views: 404

TM1 rule using DB IF and Stet

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_...
by Mark RMBC
Mon Oct 15, 2018 10:10 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting the last date of a month in TI
Replies: 10
Views: 668

Re: Getting the last date of a month in TI

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?
by Mark RMBC
Fri Sep 28, 2018 1:57 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX query using more than one cube.
Replies: 8
Views: 441

Re: MDX query using more than one cube.

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...
by Mark RMBC
Thu Sep 20, 2018 2:16 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX based on actual element compared to cube value
Replies: 4
Views: 1006

Re: MDX based on actual element compared to cube value

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 ...
by Mark RMBC
Wed Sep 19, 2018 12:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Apply Different Tax Rates
Replies: 6
Views: 801

Re: Apply Different Tax Rates

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 ...
by Mark RMBC
Thu Aug 30, 2018 10:39 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Replace hard coded rule values with cube value
Replies: 2
Views: 290

Re: Replace hard coded rule values with cube value

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
by Mark RMBC
Wed Aug 29, 2018 11:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Replace hard coded rule values with cube value
Replies: 2
Views: 290

Replace hard coded rule values with cube value

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...
by Mark RMBC
Fri Aug 17, 2018 9:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How to know last cube updated time in TM1
Replies: 7
Views: 1130

Re: How to know last cube updated time in TM1

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...
by Mark RMBC
Wed Aug 15, 2018 9:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1RPTRow with MDX Expression that Returns zero elements
Replies: 8
Views: 969

Re: TM1RPTRow with MDX Expression that Returns zero elements

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...
by Mark RMBC
Wed Aug 08, 2018 11:40 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error with MDX formula in Active Form
Replies: 3
Views: 431

Re: Error with MDX formula in Active Form

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
by Mark RMBC
Wed Aug 08, 2018 11:28 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error with MDX formula in Active Form
Replies: 3
Views: 431

Re: Error with MDX formula in Active Form

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