Search found 785 matches
- Tue Apr 23, 2024 10:32 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Can MDX work across alt hierarchies from one dim?
- Replies: 6
- Views: 100
Re: Can MDX work across alt hierarchies from one dim?
Looks like it gives me incompatible dimensionality error. Could anyone help to confirm? Thanks. e.g. Union( [dim].[a].children, [dim].[c].children ) This can't work by definition. The hierarchies are separate entities. No C elements are shared. You could use Generate to loop a set on one hierarchy ...
- Tue Apr 23, 2024 10:31 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Can MDX work across alt hierarchies from one dim?
- Replies: 6
- Views: 100
Re: Can MDX work across alt hierarchies from one dim?
No, just want to see if it is possible in a MDX set.Wim Gielis wrote: ↑Tue Apr 23, 2024 6:44 am That’s indeed incompatible. Are you not trying to make an MDX view using those 2 sets of elements (the ones that are shared) ?
- Tue Apr 23, 2024 6:01 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Can MDX work across alt hierarchies from one dim?
- Replies: 6
- Views: 100
Can MDX work across alt hierarchies from one dim?
Looks like it gives me incompatible dimensionality error. Could anyone help to confirm? Thanks.
e.g. Union( [dim].[a].children, [dim].[c].children )
e.g. Union( [dim].[a].children, [dim].[c].children )
- Sun Mar 05, 2023 11:39 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Use rule to control Logging in }CubeProperties
- Replies: 1
- Views: 559
Use rule to control Logging in }CubeProperties
Hi, all
I was under impression that we could control "LOGGIN" using a rule in the cube, but looks like it is not the case. My version is 11.8.00300.34.
I am using
The usual way from CubeSetLogChanges and cube security assignment work fine. Any idea? Thanks.
I was under impression that we could control "LOGGIN" using a rule in the cube, but looks like it is not the case. My version is 11.8.00300.34.
I am using
Code: Select all
['LOGGING'] = S: 'YES';
- Thu Feb 16, 2023 12:08 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Can I load a .cub file into TM1 without restarting?
- Replies: 7
- Views: 4123
Re: Can I load a .cub file into TM1 without restarting?
Actually.....this can be done if you have a different version of the cube already running in the TM1 Instance. Unload the cube from server explorer (right click on the cube). Replace the .cub on the disc with the replacement. Load the cube by opening a view, this may take time as it will trigger th...
- Mon Apr 04, 2022 8:56 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: check feeders not working properly in PAL 2.0.9.4
- Replies: 5
- Views: 1794
Re: check feeders not working properly in PAL 2.0.9.4
Thanks, guys. I will check it again after upgrading into a newer version.
- Mon Apr 04, 2022 4:58 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: check feeders not working properly in PAL 2.0.9.4
- Replies: 5
- Views: 1794
Re: check feeders not working properly in PAL 2.0.9.4
Thanks, mate. Deleted all blb files and reprocessed all feeders files after rebooting but no avail.burnstripe wrote: ↑Sun Apr 03, 2022 5:54 am Is there are blb file (cube_name.blb) existing when the service isn't running. If so try deleting that as well as the feeder file. And see if that remedies...
- Sat Apr 02, 2022 11:55 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: check feeders not working properly in PAL 2.0.9.4
- Replies: 5
- Views: 1794
check feeders not working properly in PAL 2.0.9.4
Hi, all Just found an interesting issue, when a cell is definitely underfed (no feeder attaching to it and not showing in 0 suppression and can't be exported with 0 suppression), the check feeders showing nothing for it and I am expecting "No Fed" value for it but showing blank. Tried unlo...
- Sat Apr 02, 2022 10:45 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Checking for Underfed cells
- Replies: 13
- Views: 6833
Re: Checking for Underfed cells
Interesting to know DebugUtility and tried to run the following code
Looks like it only produce a feeder file for the cube in PAL 2.0.9.4 after the first run.
The second run works with obfuscated data.
Code: Select all
DebugUtility( 114, 0, 0, 'myCube' , 'targetFolder' , '' );
The second run works with obfuscated data.
- Wed Mar 30, 2022 9:23 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAfE with blank windows from PAW
- Replies: 10
- Views: 2742
Re: PAfE with blank windows from PAW
Interesting, I guess it might be a bug. I used to have similar blank logging window when using PAfE to log into TM1 server with SSO authentication. However it can be resolved by using the login function on top-right server selection button from the task pane.
- Thu Mar 24, 2022 10:59 pm
- Forum: Useful code, tips and tricks
- Topic: Displaying custom error messages after running a process in PAW
- Replies: 4
- Views: 36858
Re: Displaying custom error messages after running a process in PAW
Nice one, lotsaram!
- Mon Feb 28, 2022 9:14 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Rest API - Powershell
- Replies: 6
- Views: 1775
Re: Rest API - Powershell
I haven given up Powershell as it is not pretty easy to utilize REST API. Better to choose TM1py. All functions you need from PS are available in Python and even more!
- Thu Feb 10, 2022 7:21 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: DBRW with alternative hierarchies
- Replies: 18
- Views: 22120
Re: DBRW with alternative hierarchies
I can understand performance is a big concern from IBM if they develop this formula. That's why they want to replace it with a new report type. If that solves the problem, then everyone is happy. Out of curiosity, how is DBRH performed in cubewise's slice? Has anyone use it to develop some monster r...
- Thu Feb 03, 2022 11:34 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 vs PowerBI
- Replies: 5
- Views: 18776
Re: TM1 vs PowerBI
Thanks, everyone for the sharing thoughts!
Yeah, will be more interesting to see the impact from the next generation of TM1 engine in the cloud.
Yeah, will be more interesting to see the impact from the next generation of TM1 engine in the cloud.
- Sat Jan 29, 2022 4:23 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 vs PowerBI
- Replies: 5
- Views: 18776
TM1 vs PowerBI
Hi, all I know this is not an apple to apple comparison but I just want to find out the some significant uniqueness of TM1 which is fundamentally different from Power BI. The things off the top of my head are 1. TM1 is capable of forecasting, planning and budgeting for Finance as cubes can be update...
- Sat Jan 22, 2022 7:40 am
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: TM1 REST API and Mode 5 Security / CAM
- Replies: 4
- Views: 29725
Re: TM1 REST API and Mode 5 Security / CAM
Just a check, did you have colon in your password section?
- Thu Aug 12, 2021 9:19 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: PAW Forecast Feature - Ver. 2.0.62
- Replies: 3
- Views: 3323
Re: PAW Forecast Feature - Ver. 2.0.62
Try to forecast some simple detailed cells first to see if it works.
- Mon Aug 02, 2021 8:41 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Import Views without restart
- Replies: 5
- Views: 4934
Re: Import Views without restart
put views under correct folder and unload/reload the cube to show them.
- Thu Jul 29, 2021 9:05 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: View to show first item in subset dynamically
- Replies: 12
- Views: 11541
Re: View to show first item in subset dynamically
Can't get what you are trying to achieve. If you show the MDX and some views, it would be clearer.
- Tue Jul 20, 2021 8:51 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: Failed Process only for one User while launching in TM1 Web
- Replies: 3
- Views: 3164
Re: Failed Process only for one User while launching in TM1 Web
Have you checked anything in the tm1web log?