TM1 Forum

Try change ASC to BASC

Order MDX
"...If BASC or BDESC is specified, the Order function arranges members in the set without regard to the hierarchy...."

tomok wrote: ↑

Fri Apr 16, 2021 3:37 pm

...Here is the code I use in the Data tab of a process where I do that...

Start up chore to run and update?

Thanks for the heads-up - still trying to shift some 10.2 clients!

Another thing I like to do when I have a view I am not 100% certain of is to right-click, then Export as text Data. This lets you confirm the sets/members on each dimension and if you run the export, you should end up with data in a file per the view. Per the previous posts though, you will need to ...

Going for a wild swing here as I have not seen anything either but what comes to mind is the option to Commit immediately in the Manage Features on PAW. Possibly only for the cube viewer but cannot recall exactly.
Not in a position to get the exact name or test but HTH (or someone else can).

Have you got any volatile formulas in your workbook e.g. OFFSET?

Also found it critical to use the Wait() function when triggering any refreshes via VBA to ensure that the refresh has actually completed before moving on.

I recently had to "update" a few cubes with extra dimensions to meet some new business requirements. Anyone that has done this knows that it is a complete rebuild, with exports, updating rules, feeders, views, templates etc. etc. I was able to update all the views by editing the .vue files and addin...

Tried the good old Ctrl + F5 to clear the cache?
Possibly clear cookies too.

Late here so a completely random idea but have you tried specifying the dimension name as the fourth argument in the SubsetCreatebyMDX?

Have to agree with Declan - great code Ty!

@Alan - a like button would be great in these situations

Would you not just need to add string measures to your measures dimension to store these items? p.s. Depending on your cube/model there are best practice recommendations to keep numerics in one cube and strings in another. Saying this, would be tricky to present in a grid as a dashboard though in PA...

Congratulations indeed guys!

Thanks for all the valuable contributions and making this site the “go-to” site for TM1/PA.

I have had similar issues on older versions of PAW and my notes have: To clear out all the Windows filter and other docker folders: Stop PAW then stop the Docker Service. Once done, run the below command. Download: https://github.com/jhowardmsft/docker-ci-zap PS> docker-ci-zap.exe -folder "c:\Progra...

HI Mark, There were one or two minor changes but have been able to get my old Active forms working in PAX with a few reviews and updates. Where I have a TM1RPTROW formula, I try and reference a subset or if MDX, put the MDX in a cell to make it easy to view and update. If you have used the set edito...

HI Garry, based on the AMA sessions, I am cautiously optimistic on this materialising "soon". What I have done to emulate this is to have multiple active Scenarios - Rolling Forecast plus Active 1,2 etc. The Active scenarios are flagged to be Live or Static and rules look at this. I also have system...

The right side looks to be the problem at a very quick glance. I would generally use the DB reference and put any IF statements within the DB to resolve the Cube name when valid and blank when not valid, so as not to feed. Something like: [ 'Base', 'COMMON Profit and Loss':'EBITDA' ] => DB( IF ( DB ...

ppniederbracht wrote: ↑

Fri Feb 05, 2021 9:37 pm

Try: subset:DIMENSION:SUBSET<StoreAlias=F> as picklist definition.

Thanks Paul Peter - great tip!!

Does not look like there are any other modifiers for the PicklistParser.

HI Wim,

Burnstripe is correct, you can click on the "meatballs" menu next to Cubes, Edit Settings.
The widget added to the canvas will have Cube Security on columns and you will see a plus sign (Create user group) on the right below the security shield, next to the bin.

We do exactly what Tom describes and was told to do this by IBM i.e. use TI to add Groups. You can still allocate the traditional way or via TI though.

Not sure if in the above steps you have checked the Regional Settings for the user that starts the TM1 related services - if not, try that.