Search found 1876 matches

by Wim Gielis
Mon Jan 21, 2019 8:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sorting consolidations dynamically
Replies: 1
Views: 27

Re: Sorting consolidations dynamically

In the Dimension Editorovw the elements in the correct order. Then set the order of the indexes by clicking the last icon of the menu bar.
by Wim Gielis
Sun Jan 20, 2019 11:54 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need to retrieve old values in cube
Replies: 1
Views: 177

Re: Need to retrieve old values in cube

Hi, If I understand you correctly, can't you have a *.cub file with: - December forecast values (white input cells at level 0, or Stet) - no rule that Forecast = Actual. There surely must be such a file if there is a nightly backup ? Then retrieve this cub file, along with dim files, rux file at tha...
by Wim Gielis
Sat Jan 19, 2019 9:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 coding extension for VSCode
Replies: 2
Views: 524

Re: TM1 coding extension for VSCode

But I have a question. Is there a parameter or something in the tm1s.cfg that we can change to allow direct editing of the .RUX or .PRO files ? I doubt it very much. For me, what works best until now, is using AutoHotKey to have a hotkey (F10) copy the code of the selected tab and paste into Notepa...
by Wim Gielis
Sat Jan 19, 2019 1:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Getting First children of a member
Replies: 2
Views: 85

Re: Getting First children of a member

Indeed, ELCOMP is the one you need. Could it be that the first child is again a consolidated element in the Product dimension ? Then maybe it might be an idea to store the target level 0 element as a Text attribute on the consolidated Product element where the budget data arrive. Update the attribut...
by Wim Gielis
Fri Jan 18, 2019 12:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic subset to select all leaf-level elements, except one
Replies: 4
Views: 62

Re: Dynamic subset to select all leaf-level elements, except one

I have a dynamic subset set up based on the following expression: {TM1FILTERBYLEVEL( {TM1SubsetBasis()}, 0)} It selects all leaf-level elements within the dimension. Is there a way to modify the expression to remove one particular dimension from the subset? Hello, Please remove TM1SubsetBasis and u...
by Wim Gielis
Tue Jan 15, 2019 6:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API
Replies: 20
Views: 2704

Re: TM1 REST API

Thank you Edward, bgregs. I will come back to it when time permits.
For the VBA code, that's an option. I saw the VBA code by Paul Simon on Member Unique Names, the same principles can be used from there.
I will investigate ActiveConfiguration too.
by Wim Gielis
Mon Jan 14, 2019 4:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API
Replies: 20
Views: 2704

Re: TM1 REST API

@Wim I think your point about "no additional libraries" might be misplaced. The point about libraries is to avoid re-inventing the wheel and focus on more value-adding activities. This is basically what TM1Py allows you to do and most of the hard work and abstraction of dealing with the API is alre...
by Wim Gielis
Mon Jan 14, 2019 11:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API
Replies: 20
Views: 2704

Re: TM1 REST API

No problem Lotsaram. As long as it's useful I don't mind that much.

Just a shout out, if anyone else would know of solutions to 4 out of 5 questions (see OP), while still staying in the TM1 REST API itself and not resorting to additional libraries: feel free to comment. Thanks.
by Wim Gielis
Sun Jan 13, 2019 10:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API
Replies: 20
Views: 2704

Re: TM1 REST API

Got it ! Many thanks !
04.png
04.png (26.26 KiB) Viewed 465 times
by Wim Gielis
Sat Jan 12, 2019 3:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API
Replies: 20
Views: 2704

Re: TM1 REST API

Marius, I would like to come back on the 5th item above. I will only use the TM1 REST API for a few things, one of them begin the wish to retrieve the dimension names based on a cube name. So this URL: http://aex199:8001/api/v1/Cubes('Aexis_Planning')/Dimensions?$select=Name gives me in a browser: {...
by Wim Gielis
Fri Jan 11, 2019 11:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API
Replies: 6
Views: 464

Re: TM1 REST API

1. Try to add -ContentType 'application/json' into your Invoke-RestMethod command 2. Your output is basically right but because the returned json response might be too big for Invoke-RestMethod to deserialize. You need to change to JavaScriptSerializer instead 3. For https to work, you need to refe...
by Wim Gielis
Thu Jan 10, 2019 12:33 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Remove Automatic Recalculate from View
Replies: 9
Views: 1364

Re: Remove Automatic Recalculate from View

Did you really spend some very limited time to google this ? Keywords: TM1 action button
by Wim Gielis
Tue Jan 08, 2019 10:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Indenting dimension elements in Excel
Replies: 5
Views: 286

Re: Indenting dimension elements in Excel

Hi Lotsaram,

Now I looked at it and it's marvellous. Great job !
No need to reinvent the wheel.

Wim
by Wim Gielis
Tue Jan 08, 2019 5:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Indenting dimension elements in Excel
Replies: 5
Views: 286

Re: Indenting dimension elements in Excel

lotsaram wrote:
Tue Jan 08, 2019 5:06 pm
Have you not looked in the TM1 Tools VBA at the function which "exports to Excel" a rollup?
No, I did not and I should have. Thanks for pointing out, I will have a look at it.
by Wim Gielis
Tue Jan 08, 2019 2:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Indenting dimension elements in Excel
Replies: 5
Views: 286

Re: Indenting dimension elements in Excel

Hi Wim, Another good exercise! I don't have time to test this out right now, but I will definitely take a stab at it when I get some time! I found the following function in the VBA API that looks like it _could_ be the function that returns the right information to build out the hierarchy. Again, t...
by Wim Gielis
Tue Jan 08, 2019 1:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Indenting dimension elements in Excel
Replies: 5
Views: 286

Indenting dimension elements in Excel

Hi all, Challenge of the day :lol: We start with a flat list of elements and we want to add both indenting (based on the hierarchical relationships) and also an indicator for N / C / S type elements: 02.png The start is column B, and we want to have the indentation like in the Cube Viewer. Adding "i...
by Wim Gielis
Mon Jan 07, 2019 8:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API
Replies: 20
Views: 2704

Re: TM1 REST API

Thank you very much Marius and bgregs. Good to see that it can be done, thanks. To give you a bit more background: this is not supposed to be used by users in a production environment, it's more targeted to increase my own efficiency in working with TM1. Most of all, point 2 above would be a timesav...
by Wim Gielis
Fri Jan 04, 2019 2:29 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspectives interacts with other VBA code in Personal.xlsb
Replies: 15
Views: 586

Re: TM1 Perspectives interacts with other VBA code in Personal.xlsb

Thanks bgregs.

The bug has been raised with IBM. Feedback was received after a couple of hours, yet it was useless (the numlock thing and so on).

Wim