You need to read up on TI Local Variables https://www.ibm.com/docs/sl/planning-an ... -variables
Specifically in this case DatasourceNameForServer and DatasourceCubeview
Search found 1851 matches
- Fri Apr 19, 2024 8:31 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TI Process with Cube and View Name as Parameter
- Replies: 1
- Views: 74
- Mon Apr 08, 2024 5:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX analysis of what you are feeding
- Replies: 10
- Views: 1026
Re: MDX analysis of what you are feeding
Thanks Wim, that's an interesting read, most of the items are pretty obscure. A few items stand out though TI Functions. Interesting that the ASCIIOutput function is not listed, the one thing that has been known for a long while to not be possible. Same for ExecuteCommand. AssignClientPassword - I'm...
- Mon Apr 08, 2024 12:20 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX analysis of what you are feeding
- Replies: 10
- Views: 1026
Re: MDX analysis of what you are feeding
They were pretty clear when asked that v12 on premise would not re-introduce any of the functionality that v12 containerised was removing. The loss of the Stats cubes has not really been publicised, it's a pretty big deal isn't? How are we supposed to tell we have got our designs right, if dim order...
- Mon Apr 08, 2024 10:40 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: MDX analysis of what you are feeding
- Replies: 10
- Views: 1026
Re: MDX analysis of what you are feeding
Hoping this was part of the April fool as well?
Also, in V12, the }Stats cubes are deprecated
- Mon Apr 08, 2024 10:25 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Loop Unrolling - Optimal Unrolling Factor?
- Replies: 1
- Views: 120
Re: Loop Unrolling - Optimal Unrolling Factor?
Hi, The Elpar / ElementParent function will bring back an elements parent, so if you have the levels organised as structure in the dimension then you can use this. Do take care though as if you have multiple consolidation structures in the dimension then you can't guarantee which structure you will ...
- Mon Apr 01, 2024 10:02 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Message to the TM1 Community
- Replies: 1
- Views: 864
Re: Message to the TM1 Community
Hey Wim, all the best with Jedox, but you maybe should of picked a different date to post this?
- Thu Mar 21, 2024 9:11 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Planning Analytics workspace is down
- Replies: 8
- Views: 1782
Re: Planning Analytics workspace is down
A fellow forumer also pointed out that the licensing conditions have changed as well. If you try to reinstall PAW you're going to need a HCL Mirantis licence, make sure you fully understand this before proceeding. The lack of a licence may block you from installing the product (though I don't know t...
- Wed Mar 20, 2024 4:18 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Planning Analytics workspace is down
- Replies: 8
- Views: 1782
Re: Planning Analytics workspace is down
Hi, Rolling back the install of the patches is not the same is not the same as rolling back the VM to before the patches were installed. The damage will already have been done, you need to have the VM recovered from a back-up. A simple google give you the install instructions for PAW on 2016. https:...
- Wed Mar 20, 2024 9:52 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Planning Analytics workspace is down
- Replies: 8
- Views: 1782
Re: Planning Analytics workspace is down
Not to pile in on this but Win 2016 also does not have mainstream support from Microsoft anymore.... This kind of issue really needs to be raised with IBM support but you may struggle to access this due to the age of your install. If you think drive space is the issue, just add some more and see wha...
- Wed Mar 13, 2024 9:14 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAfE Issue on Win 11
- Replies: 7
- Views: 693
Re: PAfE Issue on Win 11
Thanks burnstripe, good shout, I'll follow this up. My understanding is that IE11 is not required anymore following the move to using WebView 2.0 for all the carbon pieces but there could be a miss somewhere. I'd also expect the log-in to the SaaS environment to fail as well if it was as simple as I...
- Tue Mar 12, 2024 4:19 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAfE Issue on Win 11
- Replies: 7
- Views: 693
Re: PAfE Issue on Win 11
Hi MaranC,
Yes I'm expecting them to say the combination of PAfE and PAW is out of range of their conformance statements, hence coming here for a solution.
Will keep the thread updated as and when I hear something.
Yes I'm expecting them to say the combination of PAfE and PAW is out of range of their conformance statements, hence coming here for a solution.
Will keep the thread updated as and when I hear something.
- Tue Mar 12, 2024 1:16 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAfE Issue on Win 11
- Replies: 7
- Views: 693
Re: PAfE Issue on Win 11
Thanks burnstripe sensible suggestion but we're in the awkward situation of migrating to IBM Cloud and need to have both Cloud and on Prem available for parallel run. Would prefer not to upgrade on prem PAW if possible as then we would have to UAT that just to get through the parallel run.
- Tue Mar 12, 2024 12:36 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAfE Issue on Win 11
- Replies: 7
- Views: 693
PAfE Issue on Win 11
Hi, We are seeing the following error come up in the web page when PAfE is trying to render the set editor or cube viewer. { "error": { "code": "AUTH_REQUIRED", "message": { "authenticate": { "location": "/login" } } } } This happ...
- Thu Feb 22, 2024 9:27 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: ELPAR in Rule
- Replies: 2
- Views: 208
Re: ELPAR in Rule
For something as slow changing as this I would populate with a TI and hang the script for it off whatever TI is looking after updates to the Cost Centre dimension. This way there is no need for SecurityRefresh to get rule changes reflected in the security model, once you have to kick the system to g...
- Thu Feb 01, 2024 3:03 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Use of VBA in PA
- Replies: 5
- Views: 618
Re: Use of VBA in PA
Are you talking about publishing to TM1 Web / PASS from within PAFE
If so I don't think it is possible using VBA.
If so I don't think it is possible using VBA.
- Wed Jan 31, 2024 6:54 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Copying data between different dimensions
- Replies: 1
- Views: 438
Re: Copying data between different dimensions
Most cube to cube data transfers follow this sequence Prolog tab Define the Destination View and ViewZeroOut Define the Source View and declare it to the datasource. Data tab Update dims if required (use the direct functions) Write data Epilog Clean up objects DimensionUpdateDirect if you used the d...
- Wed Jan 31, 2024 6:43 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Can you use ConsolidatedCountUnique with criteria
- Replies: 2
- Views: 388
Re: Can you use ConsolidatedCountUnique with criteria
Hi, I'd be very careful about using the Consolidate.... family of functions. They do some strange things to the calculation engine including (I believe / been told) turn off the sparse data calculation methods (skipcheck / feeders) "underneath" them. They can lead to significant RAM growth...
- Fri Jan 26, 2024 5:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to Populate Cube thru T1 or other process
- Replies: 1
- Views: 408
Re: How to Populate Cube thru T1 or other process
Hi, It's Friday and I'm about to log so I'll be brief. Problem 1. " There is a process that deletes the ORGs and then repopulates the ORGs to bring in new orgs if there are any" Check if this is doing a DimensionDeleteAllElements, if so you should flatten the structure instead (i.e. remove...
- Mon Jan 22, 2024 11:52 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: IBM Tech Exchange - Barcalona - Now
- Replies: 0
- Views: 993
IBM Tech Exchange - Barcalona - Now
Hi, Myself and some colleagues are at the conference, anyone else here?
- Fri Jan 12, 2024 11:44 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Tm1 Instance starting up failure
- Replies: 1
- Views: 520
Re: Tm1 Instance starting up failure
Probably best to show the lines it is stopping at. My best guess is that you have persistent feeders on and this is enabling fast start-up. Sometimes it will decide to rebuild the feeders which can take a v long time and you will see the log pause on these lines for long periods. Key point is if the...