Search found 1748 matches
- Wed Nov 29, 2023 6:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Prerequisites and Challenges: PAW installation
- Replies: 6
- Views: 9382
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 ...
- 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: 7562
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 ...
- Fri Nov 10, 2023 12:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX With Member Dynamic
- Replies: 10
- Views: 12177
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...
- Thu Nov 09, 2023 9:01 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX With Member Dynamic
- Replies: 10
- Views: 12177
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...
- 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: 7175
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...
- Tue Nov 07, 2023 9:38 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX With Member Dynamic
- Replies: 10
- Views: 12177
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].[...
- 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: 761
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...
- Tue May 23, 2023 10:00 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW interface appbar
- Replies: 6
- Views: 1023
- Mon May 22, 2023 3:59 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW interface appbar
- Replies: 6
- Views: 1023
Re: PAW interface appbar
What version of PAW are you on?
I think custom themes were introduced in 76.
I think custom themes were introduced in 76.
- 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: 2401
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...
- 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: 1222
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 ...
- 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: 1466
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...
- 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: 891
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...
- Sat Mar 11, 2023 7:37 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAX exploration view automatic recalc?
- Replies: 2
- Views: 626
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" ...
- Thu Feb 23, 2023 8:02 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX filter for two dimensions
- Replies: 6
- Views: 1596
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...
- 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: 931
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...
- Tue Jan 10, 2023 8:20 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Need help on this MDX
- Replies: 11
- Views: 1462
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...
- Tue Jan 10, 2023 7:52 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Need help on this MDX
- Replies: 11
- Views: 1462
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...
- Mon Jan 09, 2023 7:12 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Need help on this MDX
- Replies: 11
- Views: 1462
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...
- 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: 976
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...