Search found 1748 matches

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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...
by declanr
Tue Jan 10, 2023 8:20 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need help on this MDX
Replies: 11
Views: 1330

Re: Need help on this MDX

Sorry, I might not have explained the whole picture. The objective is to have a cascading filter from organization dim to program dim in a cube view in PAW. That's why I cannot understand your statement can't have a user pick an element from the "Organization" dimension --- because the se...
by declanr
Tue Jan 10, 2023 7:52 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need help on this MDX
Replies: 11
Views: 1330

Re: Need help on this MDX

Yes, this was why I mentioned the currentmember being an issue. The "Organization" dimension is returning the MDX list of elements, you can't have a user pick an element from the "Organization" dimension --- because the second that they do... the MDX expression stops applying. Yo...
by declanr
Mon Jan 09, 2023 7:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Need help on this MDX
Replies: 11
Views: 1330

Re: Need help on this MDX

TM1SubsetToSet([program], IIF([organization].[parent].[Level] = "Level 0" , "Subset1", "Subset2")) It seems by this code [organization].[parent].[Level] you're trying to first grab the parent attribute of the element from the organization dimension and then the level o...
by declanr
Mon Nov 21, 2022 8:37 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Returning attribute value for MDX statement
Replies: 2
Views: 877

Re: Returning attribute value for MDX statement

If your interface is PAW or PAX you could just right click on the time dimension in the view and select show attributes. That is the quick GUI friendly way to show what you want. If you want it to be part of the view that will work in other interfaces also then I would do it by using a MEMBER calcul...