Search found 198 matches

by kangkc
Fri Jan 24, 2020 1:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI MDX query of 2 different cubes
Replies: 10
Views: 117

Re: TI MDX query of 2 different cubes

I think TSW is trying to get Cube A from Server 1 and Cube B from Server 2. Traditionally it will be like using TI to generate an interface fike from Server 1, followed by another TI in server 2 picking up the interface file and while processing the file records, CELLGETN Cube B. If this is to be au...
by kangkc
Fri Dec 20, 2019 11:49 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Rest API
Replies: 4
Views: 253

Re: TM1 Rest API

Make sure you are using NameSpace ID and not NameSpace Name.
check the Cognos Connection to confirm. ID and Name can be different.
by kangkc
Tue Nov 26, 2019 1:09 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule Question
Replies: 6
Views: 336

Re: Rule Question

Hi, thanks for help! I am working on TI process but it is not working yet. I prefer to do the rule, but I am facing some difficult too. My dimensions of period has the hierarchy as you said. I put some screenshots here. On rule you would use the ELPAR function? Can you explain more? Thanks, JR. No,...
by kangkc
Mon Nov 25, 2019 2:03 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule Question
Replies: 6
Views: 336

Re: Rule Question

Given a choice I will prefer the path of using TI to copy data from one cube to the other. It will be a very straight forward unless the dates you are storing is serial number date format which you may need some date formatting function in combination of SUBST etc. If insist of using rule, I will ju...
by kangkc
Fri Nov 08, 2019 12:27 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 REST API - GitInit
Replies: 9
Views: 484

Re: TM1 REST API - GitInit

I did managed to get GInit running without error but I was using a local repository hence may be different as I didn't want to go through a trouble of involving certificates. I did encounter some error initially and I have to explicily run a Git Init command (not using TM1 Rest) with the local repos...
by kangkc
Thu Nov 07, 2019 12:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Lock reporting periods in TM1
Replies: 1
Views: 377

Re: Lock reporting periods in TM1

A quick and flexible way, set up a locking cube comprises of Version, Year, Month which allow you to set a string value of 'Lock', 'Unlock'. Write a Cell Security rule in the Financial Reporting Cube to reference this locking cube. If the intersection of Version,Year,Month is 'Lock', set access to R...
by kangkc
Thu Oct 17, 2019 5:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 trigger Macro in Excel
Replies: 1
Views: 2544

Re: TM1 trigger Macro in Excel

No Macro, nor Power Query.
There is no Excel on TM1Web. :lol:

Only listed Excel functions as in this arcticle.
https://www.ibm.com/support/pages/list- ... -and-later
by kangkc
Thu Oct 10, 2019 12:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: "Lock" Actual Data in a forecast application
Replies: 6
Views: 4154

Re: "Lock" Actual Data in a forecast application

The usual way I do it is via cellsecurity with rule referencing a locking cube which manages which months are actuals for respective forecast scenario. With that you have full flexibility of controlling. Note that this will not work under TI which runs under Admin context and you will need to put in...
by kangkc
Thu Aug 01, 2019 1:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Two sets of count in a dimension
Replies: 1
Views: 417

Re: Two sets of count in a dimension

I think any TM1 developer which has some modeling experience should be able to model this pretty easily. Various utility admin fee can be set via reference cube. Number of units in each building, number of units using respective utility services can be stored in the main cube. The rest are just simp...
by kangkc
Thu Aug 01, 2019 1:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: REST API: Cloud
Replies: 5
Views: 1187

Re: REST API: Cloud

Based on what I understand from IBM, it will only work with non-interactive account for PA Cloud, which we have validated. CAM Namespace ID is "LDAP" based on PA Cloud welcome kit. Never manage to find out the Namespace ID for interactive account from IBM to test it out. Will be interested if this i...
by kangkc
Thu Jun 27, 2019 12:34 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM Cloud backup to local drive
Replies: 2
Views: 434

Re: IBM Cloud backup to local drive

What I did is to write a TI to invoke a Powershell script (yes, it is available in Cloud PA environment), copy to a backup folder and compress it. On-premise we have a scheduled task to initiate a FTPS client request to pull the compressed backup back to local site. Simple setup and do not need to i...
by kangkc
Thu Jun 13, 2019 7:58 am
Forum: Commercial and Events
Topic: TM1 coding extension for VSCode
Replies: 13
Views: 19569

Re: TM1 coding extension for VSCode

With the GIT support in PA 2.0.7, this may work.
by kangkc
Fri May 24, 2019 12:56 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RestAPI View has less figures Ascii Export
Replies: 10
Views: 2029

Re: RestAPI View has less figures Ascii Export

Hi, i used an VLookUp in Excel to identify the missing rows. The data doesn't look unusual and yes I re-ordered the dimensions. We are still in development, so destroy the cube and reorder the dimensions could be an option - maybe I'm in Ehingen at the "Planning Analytics TM1 Anwendertag" next week...
by kangkc
Tue May 21, 2019 1:57 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: RestAPI View has less figures Ascii Export
Replies: 10
Views: 2029

Re: RestAPI View has less figures Ascii Export

Did you re-order the cube dimensions ?
There is a bug in PA (can't recall which release) with Rest API that will cause such issues if the cube has a re-ordered dimensions. Even PAx is facing the same problem.
by kangkc
Tue Feb 12, 2019 4:41 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Auto Recalculate for Cube Viewer
Replies: 5
Views: 588

Re: Auto Recalculate for Cube Viewer

Was bored with the long rule I am writing currently and decided to take a break and investigate this. If you edit the .vue file directly, the auto-calc flag is at code 376. A value of "1" means auto-recalc. Problem is public view won't work after you manually edit until a server restart. I presume y...
by kangkc
Thu Dec 20, 2018 1:42 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: SmartCache is disabled - PA
Replies: 0
Views: 1104

SmartCache is disabled - PA

Just noticed this message in server log with TM1 Build Number: 11.2.00000.27. SmartCache is disabled I remembered Smart Caching was mentioned years ago but never get much attention after that. Was checking tm1s.cfg parameter set didn't end up anything as well. Anyone knows anything about this ?
by kangkc
Fri May 18, 2018 1:06 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: AD AP keeps disconnected in IBM cognos
Replies: 2
Views: 660

Re: AD AP keeps disconnected in IBM cognos

Are you using LDAPS (ie port 636) or LDAP (port 389) for the AD in the Cognos configuration ?
If you are using LDAPS, suggest you switch to LDAP instead and see if it resolve the issue.
by kangkc
Wed Apr 25, 2018 1:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server Locked after save data process and save data is running for a long time .
Replies: 15
Views: 7383

Re: Server Locked after save data process and save data is running for a long time .

Your issue is real. On PA instances I have also seen a lot of sf_DeleteFile and sf_SafeDelete errors, always to do with sub and/or vue files. It doesn't always occur on SaveData, sometimes it happens during TI process execution where a process that should execute in less than a second can drag on f...
by kangkc
Wed Mar 28, 2018 1:04 am
Forum: Commercial and Events
Topic: TM1 Gateway for Power BI, Tableau, MicroStrategy, R, Qlik
Replies: 21
Views: 36968

Re: TM1 Gateway for Power BI, Tableau, MicroStrategy, R, Qlik

Microsoft power BI is the leader in analytics and BI platform based on latest Gartner report. Contact us to learn more about how you can leverage both Power BI and TM1/Planning Analytics to advance your businesses using this leading analytics technology with a lower TCO. https://powerbi.microsoft.co...