Search found 1285 matches

by David Usherwood
Fri Mar 27, 2020 2:36 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Connect the ODBC on -premise with the Planning Analytics on Cloud
Replies: 5
Views: 426

Re: Connect the ODBC on -premise with the Planning Analytics on Cloud

For connecting to on premise databases:
https://www.ibm.com/uk-en/cloud/secure-gateway
If you are using IBM's SaaS PA then you will have the Workspace.
The security is done by issuing your users with IBM IDs and CAM. You can manage the groups and TM1 security is not really any different.
by David Usherwood
Sat Feb 08, 2020 9:24 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Sourcing Oracle BICS Report from TM1 cubes
Replies: 1
Views: 800

Re: Sourcing Oracle BICS Report from TM1 cubes

This looks helpful:
https://docs.oracle.com/en/cloud/paas/b ... urces.html
TM1 does not directly support inwards ODBC connections but there are a number of middleware products which will do this - google 'TM1 PowerBI' to get started.
by David Usherwood
Thu Feb 06, 2020 10:18 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unable to see slice to excel option in cube viewer
Replies: 4
Views: 1378

Re: Unable to see slice to excel option in cube viewer

As Alan said, these buttons cannot work in Architect as they create Excel content, and Architect is a standalone application. They work in Perspectives which runs as an Excel addin.
by David Usherwood
Fri Jan 31, 2020 2:12 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Archiving Data in the same Cube
Replies: 6
Views: 198

Re: Archiving Data in the same Cube

Don't skip ruled values?

Code: Select all

ViewExtractSkipRuleValuesSet (vCube, vView, 0);
by David Usherwood
Fri Jan 17, 2020 9:30 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Connect to Power BI using TM1 Rest api
Replies: 5
Views: 342

Re: Connect to Power BI using TM1 Rest api

In your earlier thread https://www.tm1forum.com/viewtopic.php?f=3&t=15092 I and others said you should use TM1PY, since PowerBI can execute Python. IMO that is the best way forward unless you pony up for one of the many middleware products which do this job rather well.
by David Usherwood
Fri Jan 10, 2020 9:48 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Tm1 Datasource for Power BI
Replies: 6
Views: 768

Re: Tm1 Datasource for Power BI

I didn't pursue this but it looks like you could use PowerBI's Python integration to link to TM1PY:
https://www.tm1forum.com/viewtopic.php? ... rbi#p71322
by David Usherwood
Tue Dec 17, 2019 3:26 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Web OR Contributor?
Replies: 3
Views: 625

Re: TM1 Web OR Contributor?

At the risk of confusing matters further, IBM's official name for 'Contributor' is 'TM1 Applications Web'. :roll:
by David Usherwood
Mon Oct 28, 2019 2:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TI process question - Mapping greyed out
Replies: 11
Views: 2443

Re: TI process question - Mapping greyed out

You have set all element 'contents' to 'other' (good idea IMO). Just write your own code above or below the (empty) generated code.
by David Usherwood
Fri Oct 25, 2019 8:59 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: MDX "JOIN"
Replies: 6
Views: 4580

Re: MDX "JOIN"

Sorry to be late on this, but what about INTERSECT?
https://www.iccube.com/support/document ... ersect.php
by David Usherwood
Tue Oct 08, 2019 3:04 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Rule causing service to go down?
Replies: 2
Views: 1881

Re: Rule causing service to go down?

If you have access to the server directory, edit the .RUX file with Notepad and comment out the problematic rule. Then look for the matching .BLB file and delete or rename it. Then restart the server.
by David Usherwood
Fri Oct 04, 2019 8:08 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: How user will add element and run process on their own?
Replies: 1
Views: 1472

Re: How user will add element and run process on their own?

Seems to me that you have not yet completed development - though it is possible that the users did not say what they needed (amazing I know, but it does happen). The solution is to build them a websheet with an action button to call the TI(s) to create the element and copy the content. Make sure you...
by David Usherwood
Wed Oct 02, 2019 8:25 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Unique identity to identify elements in TM1 subsetEditor
Replies: 1
Views: 1330

Re: Unique identity to identify elements in TM1 subsetEditor

Elements are unique in a dimension (unless you are brave enough to use the unfinished named hierarchy functionality, in which case they are unique in a hierarchy) - so DIMIX gives you the index of the element. I suggest that a clean up/deduplication of your subset would make life easier for your use...
by David Usherwood
Fri Sep 27, 2019 7:51 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Configuring rights
Replies: 1
Views: 940

Re: Configuring rights

Suggest you start here: https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_dg_dvlpr.2.0.0.doc/c_controllingaccesstotm1objects_n60007.html (It's pre PA but still applies.) High level summary: TM1/PA Security is based on groups Users are members of one or more groups...
by David Usherwood
Sun Aug 25, 2019 10:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: loading fields from csv without knowing the type of value
Replies: 6
Views: 8009

Re: loading fields from csv without knowing the type of value

Until around 2002 InfoCat did both TM1 and Lotus Notes work. I recall that there was then an ODBC driver for Lotus Notes - but Notes' data model was quite unusual in that fields could be multi valued and the multiple values did not need to be the same data type. In practice the design and usage of t...
by David Usherwood
Thu Aug 22, 2019 9:17 am
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: User at a lower level cannot view data on a chart created at a level above
Replies: 3
Views: 2486

Re: User at a lower level cannot view data on a chart created at a level above

IMO Tomok hasn't explained enough to get you to address the issue. You probably have security set up on the dimension holding your various hierarchy levels. This link should help. https://www.ibm.com/support/knowledgecenter/en/SSD29G_2.0.0/com.ibm.swg.ba.cognos.tm1_dg_dvlpr.2.0.0.doc/t_assigningsecu...
by David Usherwood
Thu Aug 01, 2019 6:02 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Dynamic query argument in TI...
Replies: 9
Views: 3807

Re: Dynamic query argument in TI...

My preference is to set the whole query up in the local variable DataSourceQuery and then write it out to a file for debugging purposes eg:

Code: Select all

datasourcequery = 'SELECT *
From A_TABLE
WHERE NUMERIC_DATE <= ' | nDate
;
asciioutput(test.csv',datasourcequery);
by David Usherwood
Fri Jul 19, 2019 4:48 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Why IBM should sell off TM1 by James Wakefield
Replies: 4
Views: 1352

Re: Why IBM should sell off TM1 by James Wakefield

I was working as a graduate consultant and asked by my boss to start learning TM1. I installed TM1 Perspectives, but then couldn't understand why companies would pay for a very bland looking pivot table product. I was then asked to install the server (version 6) and again was thinking, wow this DOS...
by David Usherwood
Tue Jun 11, 2019 2:41 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: TM1 Perspective Vs Pax
Replies: 10
Views: 2603

Re: TM1 Perspective Vs Pax

From what I can see the aim is for PAW to take on the developer admin tasks and PAX to be purely Excel reporting and budgeting. Even on these there is a way to go since PAX does not support the new named hierarchies in Dynamic (or Static) Reports so the best way to generate decent interactive report...
by David Usherwood
Thu Jun 06, 2019 2:52 pm
Forum: IBM TM1, Planning Analytics, PAx and PAW
Topic: Manage Rights when a big chunk of elements are deleted
Replies: 11
Views: 1244

Re: Manage Rights when a big chunk of elements are deleted

It's the TI command CellSecurityCubeCreate, supported in 10.2.something onwards:

Code: Select all

https://www.tm1forum.com/viewtopic.php?f=3&t=11423&p=54152#p54152