Search found 181 matches

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

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: 14
Views: 1877

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: 19
Views: 11275

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...
by kangkc
Wed Mar 21, 2018 8:21 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Missing TM1 objects: file format is too new
Replies: 2
Views: 680

Re: Missing TM1 objects: file format is too new

I only remember there is a object structure change in 10.2.2 FP7 IF4 which caused the objects incompatible with lower release of TM1 (FP7 and below). http://www-01.ibm.com/support/docview.wss?uid=swg22008561 But in your case Server B is at FP6. :roll: Unless there are some other objects changes betw...
by kangkc
Wed Feb 28, 2018 10:53 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Exporting changed data only - flag?
Replies: 8
Views: 1118

Re: Exporting changed data only - flag?

Did you attempt to isolate where the bottleneck is ?

In many cases this is at the DB (SQL?) end as ODBCOuput is not really an optimum way to upload into RDBMS.

Also how do you clear the current data in table before insert ? Delete or Drop table ? All this will have impact to the overall run time.
by kangkc
Tue Feb 06, 2018 1:05 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tools to copy and rename TM1 object
Replies: 6
Views: 695

Re: Tools to copy and rename TM1 object

You can try GrepWin :
https://sourceforge.net/projects/grepwin/

However, it's not that straight forward with rule as you will need to deal with both .rux and the corresponding .blb.
Should works fine with .pro
by kangkc
Tue Feb 06, 2018 1:03 am
Forum: Commercial and Events
Topic: TM1 Gateway for Power BI, Tableau, MicroStrategy, R, Qlik
Replies: 19
Views: 11275

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

We have just released Version 2.1.0. Highlights of the new release: - New Cache Engine with more dynamic cache control - Scalability and performance improvement to balance server resources and large data set request that goes beyond tens/hundreds of millions Please send us an email for details about...
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: 7
Views: 939

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

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

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

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

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

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: 19
Views: 11275

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

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: 19
Views: 11275

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

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

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...