Search found 174 matches

by kangkc
Fri Jan 19, 2018 2:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Using Alternative Hierarchies to calc stock balances
Replies: 6
Views: 125

Re: Using Alternative Hierarchies to calc stock balances

The ^ character if I am not wrong is supposed to be used internally partly due to MDX. There was a bug with Set Editor that resulted in this character being exposed when using Subnm under PAX but this has been resolved with later PAX releases. SUBNM returned with the ^ character separating the level...
by kangkc
Wed Jan 17, 2018 10:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: 2 instance 1 server
Replies: 2
Views: 148

Re: 2 instance 1 server

Rest API Port via the parameter :
HTTPPortNumber

If not specified, default is 5001 (PA 2.x), hence conflict.
by kangkc
Mon Jan 15, 2018 12:22 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Snapshot feasibility in TM1
Replies: 2
Views: 166

Re: Snapshot feasibility in TM1

I think Perspective "Print Report with snapshot option" is what you are looking for.
by kangkc
Wed Nov 22, 2017 11:47 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sum on TM1 Cube
Replies: 5
Views: 271

Re: Sum on TM1 Cube

If you are on PA, store the client name as attribute and use the attribute as hierarchies. But again this will only work with PAx, Workspace but a more efficient and memory friendly way.
by kangkc
Tue Nov 14, 2017 11:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: IBM Planning Analytics Active Directory
Replies: 2
Views: 213

Re: IBM Planning Analytics Active Directory

http://www-01.ibm.com/support/docview.w ... wg22000283

Many steps to follow but this is the only way now for all PA components.

Alternatively you can wait for the next update from IBM which promise a mode 3 with PAW.
by kangkc
Mon Nov 06, 2017 8:00 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Problem restoring model (some cubes are missing from list)
Replies: 2
Views: 258

Re: Problem restoring model (some cubes are missing from list)

I would check tm1server.log to see if there are any error.
by kangkc
Tue Oct 10, 2017 1:33 am
Forum: Commercial and Events
Topic: TM1 Gateway for Power BI, Tableau, MicroStrategy, R, Qlik
Replies: 17
Views: 7160

Re: TM1 (PA) Gateway for Power BI, Tableau, MicroStrategy, Qlik

We have just released TMVGate version 2.0 which officially support PA 2.0 virtual hierarchies. Along with the new release comes with other enhancement such as caching, standalone URL generator, MDX support. Please send us an email if you want to enquire about the product. Email: info@itlinkbiz.com
by kangkc
Thu Aug 17, 2017 12:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Secure Gateway on the IBM Cloud
Replies: 4
Views: 500

Re: TM1 Secure Gateway on the IBM Cloud

https://...your cloud url..../control
by kangkc
Wed Aug 16, 2017 8:18 am
Forum: Commercial and Events
Topic: TM1 Gateway for Power BI, Tableau, MicroStrategy, R, Qlik
Replies: 17
Views: 7160

TM1 (PA) Gateway for Power BI using Natural Query

We just uploaded a new business case of using TM1 (PA) gateway with Power BI natural query to analyze TM1 (PA) data using plain English.
See the demo youtube video:

https://youtu.be/LYuj-pFYBxM

Please contact us at info@itlink.com.sg for product enquiry.
by kangkc
Tue Aug 15, 2017 9:15 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Pmhub Configuration
Replies: 3
Views: 393

Re: Pmhub Configuration

The configuration should be in fpmsvc_config.xml file in the \webapps\pmpsvc\WEB-INF\configuration\ folder, or at least in 10.2.x.
by kangkc
Tue Aug 08, 2017 1:27 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Is there a free way to move data from cube to Tableau?
Replies: 10
Views: 1244

Re: Is there a free way to move data from cube to Tableau?

In the most simplistic way, yes. Export cube view and import into Tableau. But things get slightly complicated if you need hierarchy structure. Most likely you will need to build TI that will export the hierarchy structure together with the data. Moreover this will be unique to a specific cube/cubes...
by kangkc
Tue Jul 18, 2017 9:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics Workspace - Native support now available for Windows 2016
Replies: 8
Views: 836

Re: Planning Analytics Workspace - Native support now available for Windows 2016

Great. Keep us posted.
By the way, monitor the memory as I am testing it under a 16GB machine and for some reason I keep running out of memory though I am using the standard tiny sample SData instance under PA 2.0.1.
by kangkc
Tue Jul 18, 2017 6:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics Workspace - Native support now available for Windows 2016
Replies: 8
Views: 836

Re: Planning Analytics Workspace - Native support now available for Windows 2016

I was testing this since last week and not really getting positive result as Native Docker for Windows will use Windows Container and that resulted in massive Windows components being pull down and the MongoDB component in my case keep crashing and I can't get all the required services running due t...
by kangkc
Mon Jul 10, 2017 1:44 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Control Cube for Managing Views
Replies: 4
Views: 577

Re: Control Cube for Managing Views

I will probably use a cube to store the the view definition and drive through the view creation via TI (or REST API). But again you will have complication such as subsets to be used and the definition you put in as the view definition "cube" will not have any idea the validity of he subset chosen un...
by kangkc
Wed Jun 07, 2017 2:13 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics Local 2.0: Multiple Hierarchies
Replies: 19
Views: 4031

Re: Planning Analytics Local 2.0: Multiple Hierarchies

thanks kankc, how do I do that in PAX, the save button in ribbon is greyed out and there is no 'save' in MDX, also where does it save too? Also found this https://community.watsonanalytics.com/discussions/questions/26988/using-the-new-hierarchy-feature-with-tm1-perspecti.html My apology as I should...
by kangkc
Tue Jun 06, 2017 12:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Planning Analytics Local 2.0: Multiple Hierarchies
Replies: 19
Views: 4031

Re: Planning Analytics Local 2.0: Multiple Hierarchies

Just a point to note, by design it looks like, you cannot save a view back to TM1 server that uses an alternative hierarchy. Meaning you need to save a workbook in PAX, or save a 'Book' with the 'View' in PAW. Cant see how to manage otherwise, unless anyone else has found a solution? I think for ex...
by kangkc
Wed May 24, 2017 12:36 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Server Data folder backup
Replies: 9
Views: 699

Re: Server Data folder backup

In our case I separate the Save data and Zip in separate process with a window of 30 mins in between.
Possible that the Save Data actually takes a long time ? Quite common though.