Search found 1752 matches

by declanr
Mon Jun 24, 2024 11:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: mdx statement to determine parent from parallel hierarchy
Replies: 4
Views: 504

Re: mdx statement to determine parent from parallel hierarchy

The below code concept should work for you. Generate ( {TM1SubsetToSet([<Dim1>].[<Hier1>] , "N_Level_Set" , "Public")}, {StrToMember ( "[<Dim2>].[<Hier2>].[P" + Right ( [<Dim1>].[<Hier1>].CurrentMember.Properties("Member_Name"), 6 ) + "]" )} ) Genera...
by declanr
Fri Jun 21, 2024 6:14 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Use of + in Element names
Replies: 1
Views: 123

Re: Use of + in Element names

I've never used it as an actual element name; but I regularly use "-" as a calculated member in MDX views to create spacing rows and columns.
I've never had any issues with that in PAW or PAFE.
by declanr
Fri May 31, 2024 3:30 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Average calculation using TI process
Replies: 3
Views: 1020

Re: Average calculation using TI process

Looking at the requirement I would probably be inclined to just go with a couple of while loops as a simple implementation; then check that the performance is good/acceptable - if its not I would investigate other options. I gather from your query that if the target range is Jan - Dec; the Jan shoul...
by declanr
Fri May 24, 2024 9:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Block user in PAL
Replies: 3
Views: 4017

Re: Block user in PAL

Hi,

I haven't used it in a while but there is an "IsDisabled" flag in the }ClientProperties cube.
If you put a 1 in there it should stop the user from being able to connect.

Thanks,
Declan
by declanr
Wed Nov 29, 2023 6:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Prerequisites and Challenges: PAW installation
Replies: 6
Views: 9621

Re: Prerequisites and Challenges: PAW installation

This is one of those rock and a hard place requirements. It would be impossible for IBM or anyone to say that it is impossible to get viruses or issues in a certain place. Now to run on windows you should exclude it (depending on virus software used) to guarantee a good service level. So then if an ...
by declanr
Sat Nov 11, 2023 7:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to ViewZeroOut }bedrock.cube.view.create
Replies: 3
Views: 7685

Re: Unable to ViewZeroOut }bedrock.cube.view.create

I haven’t used the bedrock processes before but looking at the parameters you are passing a 1 to a “temp” parameter. So most likely this is creating the views as temporary views which get destroyed at the end of the thread. In the earliest release that included the temp option it could only be used ...
by declanr
Fri Nov 10, 2023 12:03 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX With Member Dynamic
Replies: 10
Views: 12709

Re: MDX With Member Dynamic

Good information Declan. In the first code snippet, I would calculate the variance based on the 2 variables above. Less hardcoded elements, shorter code too. Yes, that's what the second code snippet was showing how to do. However, it's only really needed because of the issues that Maren has encount...
by declanr
Thu Nov 09, 2023 9:01 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX With Member Dynamic
Replies: 10
Views: 12709

Re: MDX With Member Dynamic

Hi Maren, What you've described shouldn't be an issue at all. I would suggest raising an incident with IBM to see if there are issues with the version you are running; I do a lot of period comparisons very similar to what you have described that have worked for a number of years. I built a small moc...
by declanr
Wed Nov 08, 2023 10:04 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic subset - Reference cube with different Dimensions
Replies: 2
Views: 7249

Re: Dynamic subset - Reference cube with different Dimensions

So first thing when you want to retrieve the value in a cell you need to get it in format: [cubename].([dimname1].[elementname1],[dimname2].[elementname2]…) The concatenation of dim name and element name above is a member unique name (you can also add an extra square bracket in the middle with hiera...
by declanr
Tue Nov 07, 2023 9:38 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX With Member Dynamic
Replies: 10
Views: 12709

Re: MDX With Member Dynamic

Looks like you are missing closing the square bracket on the wrapped strtomember: WITH MEMBER [Period].[Period].[Prev - Curr Period] AS STRTOMEMBER("[Period].[Period]." + STRTOMEMBER( "[Period].[" + [System Variables].([System Variables Lines].[Latest Actual Period],[Data Type].[...
by declanr
Mon Jul 31, 2023 6:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SQLState: S1000 SQLMsg: [Oracle][ODBC][Ora]ORA-08103: object no longer exists
Replies: 1
Views: 939

Re: SQLState: S1000 SQLMsg: [Oracle][ODBC][Ora]ORA-08103: object no longer exists

What is the query? Is it against a table or something else? It's certainly not unheard of for the error messages to be misleading but "object no longer exists" is not one I have come across before. I wonder if its something like a stored procedure to return a view but another user has exec...
by declanr
Tue May 23, 2023 10:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW interface appbar
Replies: 6
Views: 1151

Re: PAW interface appbar

monkey97 wrote: Tue May 23, 2023 9:04 am2.0.72
Yes, you will need to upgrade workspace to a more recent version in order for that feature to be available.
by declanr
Mon May 22, 2023 3:59 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAW interface appbar
Replies: 6
Views: 1151

Re: PAW interface appbar

What version of PAW are you on?
I think custom themes were introduced in 76.
by declanr
Tue May 02, 2023 3:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule to sum all elements except the current?
Replies: 11
Views: 2757

Re: Rule to sum all elements except the current?

Nope the problem would have to do with a circular referencation. If I'd write: ["Element 3"] = N: ["All Elements"] - [!Element] TM1 would be kinda displeased :-D What is the cube structure you are working with and what are you trying to get a sum of? As long as you have a measur...
by declanr
Wed Mar 22, 2023 9:14 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Add an element to a control dimension with non-Admin user ID?
Replies: 7
Views: 1529

Re: Add an element to a control dimension with non-Admin user ID?

Hi, You need to use the AddGroup function, not dimensionelementinsert. Maren DimensionElementInsert or AddGroup will work; the }Groups dimension is a dimension just like any other. Similar to how you can use CellPutS on the }ClientGroups cube instead of AssignClientToGroup - the difference is that ...
by declanr
Fri Mar 17, 2023 6:35 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Generic Ti for Multiple Cubes - Archive Versions
Replies: 10
Views: 1851

Re: Generic Ti for Multiple Cubes - Archive Versions

This is exactly how I set up version archiving processes in all of my models. You've described the master process perfectly. So for the slave process you need to: Check how many dimensions are in the Cube on the prolog Create your process using a dummy source (something with at least as many variabl...
by declanr
Sun Mar 12, 2023 6:11 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX - How to use subset from one hierarchy to filter and generate subset on another hierarchy
Replies: 2
Views: 1022

Re: MDX - How to use subset from one hierarchy to filter and generate subset on another hierarchy

Something like the below should work; it sounds like you were on the right track. The trick is to think of hierarchies as completely separate entities, so you can take the "Name/Description" of an element from one (but that could come from anywhere as its just a bit of text) and the Member...
by declanr
Sat Mar 11, 2023 7:37 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: PAX exploration view automatic recalc?
Replies: 2
Views: 719

Re: PAX exploration view automatic recalc?

As George has suggested the version being used could be useful. To the best of my knowledge the behavior of "changing dimension order" should be the same whether in manual or automatic calculation mode for Excel. There is an option called "Design Mode" under the "Data" ...
by declanr
Thu Feb 23, 2023 8:02 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX filter for two dimensions
Replies: 6
Views: 2014

Re: MDX filter for two dimensions

And in terms of the MDX view that Wim mentioned you would want to use code like below: SELECT {[Measure].[Measure].MEMBERS} ON 0, {Filter( {[Order#].[Order#].MEMBERS}*{[Line].[Line].MEMBERS}, [Test].([Measure].[Flag])<>"Inactive")} ON 1 FROM [CubeName] Within the Filter section; you are co...
by declanr
Sat Jan 14, 2023 7:24 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1web global Homepage Setting for two instance
Replies: 2
Views: 1023

Re: TM1web global Homepage Setting for two instance

In each TM1 instance, you can set a homepage per user in the }ClientSettings cube. After logging in the user will be redirected to whichever page you set here. Since the }ClientSettings cube is different per instance, but the same client can exist in both - this allows the same user to be directed t...