Search found 785 matches

by macsir
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: 83

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 ...
by macsir
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: 83

Re: Can MDX work across alt hierarchies from one dim?

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) ?
No, just want to see if it is possible in a MDX set.
by macsir
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: 83

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 )
by macsir
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

Code: Select all

['LOGGING'] = S:  'YES';
The usual way from CubeSetLogChanges and cube security assignment work fine. Any idea? Thanks.
by macsir
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...
by macsir
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. :)
by macsir
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

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...
Thanks, mate. Deleted all blb files and reprocessed all feeders files after rebooting but no avail. :(
by macsir
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...
by macsir
Sat Apr 02, 2022 10:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Checking for Underfed cells
Replies: 13
Views: 6832

Re: Checking for Underfed cells

Interesting to know DebugUtility and tried to run the following code

Code: Select all

DebugUtility( 114, 0, 0, 'myCube' , 'targetFolder' , '' );
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.
by macsir
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: 2741

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.
by macsir
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!
by macsir
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...
by macsir
Thu Feb 03, 2022 11:34 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 vs PowerBI
Replies: 5
Views: 18771

Re: TM1 vs PowerBI

Thanks, everyone for the sharing thoughts! :D
Yeah, will be more interesting to see the impact from the next generation of TM1 engine in the cloud.
by macsir
Sat Jan 29, 2022 4:23 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 vs PowerBI
Replies: 5
Views: 18771

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...
by macsir
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?
by macsir
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: 3322

Re: PAW Forecast Feature - Ver. 2.0.62

Try to forecast some simple detailed cells first to see if it works.
by macsir
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.
by macsir
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.