Search found 389 matches

by PavoGa
Fri Jan 17, 2020 3:48 pm
Forum: Useful code, tips and tricks
Topic: Going to the IBM Cloud
Replies: 1
Views: 28

Re: Going to the IBM Cloud

Good stuff. Thanks.
by PavoGa
Wed Jan 15, 2020 6:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cannot add Action button to existing websheet
Replies: 1
Views: 63

Re: Cannot add Action button to existing websheet

Just bump this and provide our resolution. I rebuilt the websheet. And had no problem then adding an action button. Guess something in it was not gee hawing with the latest upgrade and switch to CAM security we are currently doing. Now the only problem is that we have several web sheets, not all by ...
by PavoGa
Sun Jan 12, 2020 3:28 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 MDX in TI Process
Replies: 14
Views: 428

Re: TM1 MDX in TI Process

I think I know what your problem is. The clue about the problem is that it only returns values when the other dimensions, not referenced in the dimEmp MDX, are placed as context items in the view, but when placed as row dimensions produce no results. When those other dimensions are placed as context...
by PavoGa
Fri Jan 10, 2020 7:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Cannot add Action button to existing websheet
Replies: 1
Views: 63

Cannot add Action button to existing websheet

I have an existing web sheet for which I am unable to add an action button. I click action button and nothing happens. No action button window. Other existing web sheets have no problem. Open another one up, click add action button and works like a charm. Start a new web sheet, no problem. Have not ...
by PavoGa
Sat Jan 04, 2020 2:11 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error Getting Subset Properties
Replies: 2
Views: 85

Re: Error Getting Subset Properties

No, strictly native views in architect and tm1web. Yes, all the views have at least one dimension on the columns. And what you suggested is a better solution than the currentmember idea. Was not looking for a solution. We kept running into it occasionally and were working around it a couple of diffe...
by PavoGa
Fri Jan 03, 2020 7:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Consolidation
Replies: 12
Views: 225

Re: Consolidation

I think I'm with Steve on this, but if this is the structure you want, have you tried the MAX() function? Assuming not all the Functional and MVS leaves are populated, that should work. If all are populated, then simply get the values of the first component in the Total Functional consolidation. The...
by PavoGa
Fri Jan 03, 2020 3:43 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Error Getting Subset Properties
Replies: 2
Views: 85

Error Getting Subset Properties

@bgregs and I were having an issue (and strenuous discussion!) about the cause of this error when opening or refreshing a cube view. Could not find a clear answer on the forum and both of us had a different solution without really knowing the why. It is MDX related. The problem arises if a cube view...
by PavoGa
Mon Dec 23, 2019 8:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Subsets and Views not registering after Restart
Replies: 13
Views: 785

Re: Subsets and Views not registering after Restart

Agree with lotsaram, just the way it is and handled it the same way. Have a TI that reads the sub files at start up and recreates them.

However, now I use copies of those dimensions instead.
by PavoGa
Fri Dec 13, 2019 1:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: View not loading in TI Process
Replies: 8
Views: 477

Re: View not loading in TI Process

Have you checked the dimension order? I have had performance issues with a cube that reordering the dimensions resolved.
by PavoGa
Wed Dec 11, 2019 4:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Temporary views surviving their TI process
Replies: 10
Views: 311

Re: Temporary views surviving their TI process

And yet another reminder why reading release notes and such is important. :D
by PavoGa
Tue Dec 10, 2019 7:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Temporary views surviving their TI process
Replies: 10
Views: 311

Re: Temporary views surviving their TI process

I think you might actualy be exploiting a bug Ty. AFAIK assigning a permanent subset to a temp view isn't supposed to work and you may find that on next upgrade all processes using this "feature" break. I would try and confirm with IBM support if this is actually supposed to work. We will find out ...
by PavoGa
Mon Dec 09, 2019 9:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Temporary views surviving their TI process
Replies: 10
Views: 311

Re: Temporary views surviving their TI process

A sub-process creates a temporary view using a non-temporary subset from another sub-process. Are you sure? As in are you sure, you're sure? In my experience trying to assign a temp subset to a non-temp view (or vice versa) will result in an error and the process aborting. So if you are managing to...
by PavoGa
Mon Dec 09, 2019 6:53 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Temporary views surviving their TI process
Replies: 10
Views: 311

Re: Temporary views surviving their TI process

Any chance you could share some code? Not sure there is really any code to share. In this case, I just use the ViewDestroy in the offending sub-process EPILOG and that took care of it. This instance was unusual as I normally build all my subsets as temporary within the process they are to be used w...
by PavoGa
Mon Dec 09, 2019 2:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Temporary views surviving their TI process
Replies: 10
Views: 311

Temporary views surviving their TI process

Ran into this last week. A sub-process creates a temporary view using a non-temporary subset from another sub-process. That view is surviving its process and the master process, which tries to delete the subset in its EPILOG, is aborted because the subset it tries to destroy is reported as existing ...
by PavoGa
Wed Oct 30, 2019 8:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Best Practice : Migration into a production environment
Replies: 7
Views: 6415

Re: Best Practice : Migration into a production environment

Yeah, Beyond Compare is certainly better than WinMerge without question (I use it internally), especially comparing code and JSON data, but in a lot of places we go where the customer doesn't have it, getting authorization to purchase a product takes a lot of time and paperwork. WinMerge seems to g...
by PavoGa
Wed Oct 30, 2019 2:20 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill-through to a cube view
Replies: 20
Views: 8824

Re: Drill-through to a cube view

There isn't a view name listed in any of the TM1 user interfaces. However, you basically have full control of the Drill-Through "view" that it creates, except with the limitations of the Title dimensions as mention earlier. It wouldn't surprised me If this is unique to PA 2.0.8. Gotcha. I would not...
by PavoGa
Tue Oct 29, 2019 6:08 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Max Value
Replies: 13
Views: 8940

Re: Max Value

One way I can think of is if you have a rolling 24 consolidation, then ConsolidatedMax should be able to do it.
by PavoGa
Tue Oct 29, 2019 4:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill-through to a cube view
Replies: 20
Views: 8824

Re: Drill-through to a cube view

This works on new subsets/views on rows and columns with some stipulations. After further testing, TM1 doesn't actually pull up the new view during drill-through but rather takes some of its parameters. Because the Drill-Through is not actually a saved view, there isn't a reload view button but the...
by PavoGa
Fri Oct 25, 2019 9:43 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX "JOIN"
Replies: 6
Views: 3824

Re: MDX "JOIN"

David Usherwood wrote:
Fri Oct 25, 2019 8:59 am
Sorry to be late on this, but what about INTERSECT?
https://www.iccube.com/support/document ... ersect.php
Intersect requires the same dimensionality in both sets. Tom is asking for the inner join of two dimensions.