Search found 375 matches

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: 6103

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: 8260

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: 8693

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: 8260

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: 3624

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.
by PavoGa
Thu Oct 24, 2019 5:25 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX "JOIN"
Replies: 6
Views: 3624

Re: MDX "JOIN"

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...
by PavoGa
Thu Oct 24, 2019 1:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Variable/Parameters in MDX
Replies: 3
Views: 3900

Re: Variable/Parameters in MDX

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] <=...
by PavoGa
Wed Oct 23, 2019 12:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Issue with Parallel TI
Replies: 4
Views: 5687

Re: Issue with Parallel TI

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.
by PavoGa
Wed Oct 23, 2019 12:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Best Practice : Migration into a production environment
Replies: 7
Views: 6103

Re: Best Practice : Migration into a production environment

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...
by PavoGa
Wed Oct 23, 2019 12:13 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Best Practice : Migration into a production environment
Replies: 7
Views: 6103

Re: Best Practice : Migration into a production environment

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...
by PavoGa
Tue Oct 22, 2019 2:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Best Practice : Migration into a production environment
Replies: 7
Views: 6103

Re: Best Practice : Migration into a production environment

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...
by PavoGa
Tue Oct 22, 2019 2:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Drill-through to a cube view
Replies: 20
Views: 8260

Re: Drill-through to a cube view

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...
by PavoGa
Mon Oct 21, 2019 12:31 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: What is used by whom? and for what purpose?
Replies: 2
Views: 5984

Re: What is used by whom? and for what purpose?

@tomok

I think this one is for you. :D
by PavoGa
Fri Oct 18, 2019 12:44 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Compare Development and Production Server
Replies: 5
Views: 3709

Re: Compare Development and Production Server

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...
by PavoGa
Fri Oct 18, 2019 12:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Difference between TI Text and Cube View
Replies: 8
Views: 4085

Re: Difference between TI Text and Cube View

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...
by PavoGa
Wed Sep 25, 2019 4:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Session Variables & RunProcess bug?
Replies: 0
Views: 6563

Session Variables & RunProcess bug?

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...
by PavoGa
Sat Sep 14, 2019 8:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX statement when having two dimensions on the rows in Active form
Replies: 2
Views: 392

Re: MDX statement when having two dimensions on the rows in Active form

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.
by PavoGa
Thu Aug 22, 2019 2:23 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How do I increase my knowledge and basic concepts of tm1?
Replies: 8
Views: 5384

Re: How do I increase my knowledge and basic concepts of tm1?

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

Wim's MDX page is very good.
by PavoGa
Wed Aug 21, 2019 12:32 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How & why corrupted views of a cube is generated?
Replies: 8
Views: 4710

Re: How & why corrupted views of a cube is generated?

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