TM1 Forum

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

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

If you were to use EXPAND instead of string concatenations, the numeric values are handled. For example: sMDX = EXPAND('intersect( Filter( TM1SubsetAll( [ContinuousTime] ), [ContinuousTime].[PreviousNumber] >= %vEndNo% ), Filter( TM1SubsetAll( [ContinuousTime] ), [ContinuousTime].[PreviousNumber] <=...

Are the threads going into a wait state while one finishes? If so, then probably a locking issue. A likely culprit is if this process is making any metadata changes.

This is pretty much exactly the use case that bedrock.hier.export.script was developed for. The process exports as TI code the script required to build dimensions (or hierarchies). There are options to filter on particular elements, attribute definitions, etc. It's a super easy way to generate this...

While you certainly can do it manually, it is error prone, and it doesn't catch things that are data and metadata related. Using Beyond Compare or WinMerge tools are great for processes and rules, but when it comes to comparing dimensions, or attribute data, or even cube data, that is where the man...

There are a number of different methods, many of which are elucidated on this forum. However, working two simple scenarios: 1) migrating everything from DEV to Prod Shutdown both servers (or run Save Data on DEV) and copy the DEV\data folder to PROD\data folder. Restart Prod instance. 2) migrating s...

This has been awhile, but needed to update it (got a question on it today). If the subsets and the view exist and are updated, not created fresh, the drill through works fine with customized subset and view definitions. To avoid user conflicts, we added views on each cube and subsets on dimensions w...

@tomok

I think this one is for you.

Beyond Compare (BC). I've used winmerge, but BC is better at matching up lines without false positives and tons of features. Use it for awhile and you'll throw rocks at winmerge. We have four environments (D, Q, S and P) that our code moves through and BC sessions are easy to setup to allow quick co...

I do not know if this is what lotsaram was referring to, but an alternative is to use SLEEP(n) after the ExecuteCommand where n = milliseconds as another way of giving PS time to complete. With ExecuteCommand, if something goes wrong in the called script and it gets hung up, your TI will sit there p...

We have found that if the value of a session variable changes during a session, any processes executed through RunProcess will use the original session variable value setting . The value changes when the client logs out and back in. All processes executed directly as part of the user's current sessi...

If an account has different spread methods depending on the BU, this cannot be done in a regular cube view with both dimensions on the rows. It can be done with the BU as a title dimension.

You might can in a websheet.

Have not seen it mentioned, but the Bedrock White Papers are excellent resources as well.

Wim's MDX page is very good.

In my experience this happens when a view has been saved with static subsets or selected elements. Someone then deletes these elements effectively returning a null set and the view breaks. There are probably other reasons but the above is probably a frequent occurrence for newer users who do not us...