Search found 782 matches

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: 544

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: 4101

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: 1771

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: 1771

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: 1771

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: 6747

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: 2663

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: 1741

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: 22056

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: 18660

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: 18660

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: 29695

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: 3290

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: 4913

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: 11476

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

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

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);
by macsir
Mon Jul 05, 2021 12:45 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Performance Monitor was on by itself
Replies: 2
Views: 3181

Re: Performance Monitor was on by itself

I’m on 2.0.9.6 and have seen the same. It seems when I turn on Performance Monitor in Architect, it persists through a restart by changing that setting to T. Yes, exactly. And it worked once when I put PerformanceMonitorOn=F explicitly in the config file. But later, somehow it was changed to Perfor...