TM1 Forum

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 ...

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...

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 ...

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...

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...

@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...

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.

Have you checked the dimension order? I have had performance issues with a cube that reordering the dimensions resolved.

And yet another reminder why reading release notes and such is important.

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...

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...

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...

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 ...

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...

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...

Have you tried aliases on the cube to get around the accented characters?

One way I can think of is if you have a rolling 24 consolidation, then ConsolidatedMax should be able to do it.

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...

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.

Here is another method that uses GENERATE as gtonkin suggests, but does not require the StrToMember. A subset we use: GENERATE( TM1DRILLDOWNMEMBER( {[Employee].[Non-Active Employees]}, ALL) , FILTER( TM1SUBSETALL([Employee - Historical]) , [Employee - Historical].currentmember.name = [Employee].curr...