Looks like it gives me incompatible dimensionality error. Could anyone help to confirm? Thanks.
e.g. Union( [dim].[a].children, [dim].[c].children )
Search found 783 matches
- 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: 0
- Views: 6
- 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: 557
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: 6830
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: 2738
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: 36854
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: 1774
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: 22119
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: 18769
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: 18769
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: 29723
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: 3321
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: 11539
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?
- Tue Jul 20, 2021 8:49 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: CCC scheduled tasks failing on Cloud
- Replies: 4
- Views: 5043
Re: CCC scheduled tasks failing on Cloud
Just out of curiosity, how good is IBM cloud on average? (I mean PA on cloud) Seems like no one has discussed about it here.
- Tue Jul 13, 2021 9:09 pm
- Forum: IBM TM1, Planning Analytics, PAx and PAW
- Topic: How to calculate up to Millisecond
- Replies: 18
- Views: 68600
Re: How to calculate up to Millisecond
Yes, I agree with declanr. DimensionTimeLastUpdated and HIERARCHYTIMELASTUPDATED need to be converted from GMT time to local time.
Code: Select all
#If converted to local time, need to add 10 / 24 for hour difference
vDateTimeWithMillisec = NUMBERTOSTRING((DimensionTimeLastUpdated(DimName)) + 10/24);