TM1 Forum

David Usherwood

Look at SubsetMDXSet.

David Usherwood

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.

David Usherwood

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.

David Usherwood

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.

David Usherwood

Don't skip ruled values?

Code: Select all

ViewExtractSkipRuleValuesSet (vCube, vView, 0);

David Usherwood

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.

David Usherwood

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

David Usherwood

At the risk of confusing matters further, IBM's official name for 'Contributor' is 'TM1 Applications Web'.

David Usherwood

You have set all element 'contents' to 'other' (good idea IMO). Just write your own code above or below the (empty) generated code.

David Usherwood

Sorry to be late on this, but what about INTERSECT?
https://www.iccube.com/support/document ... ersect.php

David Usherwood

This might be useful to get you started:
https://www.tm1forum.com/viewtopic.php? ... 913#p73971

David Usherwood

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.

David Usherwood

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

David Usherwood

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

David Usherwood

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

David Usherwood

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

David Usherwood

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

David Usherwood

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);

David Usherwood

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

David Usherwood

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

TM1 Forum

Search found 1346 matches

Re: SubsetCreate by MDX

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

Re: Sourcing Oracle BICS Report from TM1 cubes

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

Re: Archiving Data in the same Cube

Re: Connect to Power BI using TM1 Rest api

Re: Tm1 Datasource for Power BI

Re: TM1 Web OR Contributor?

Re: TI process question - Mapping greyed out

Re: MDX "JOIN"

Re: Can we add security to an action button?

Re: Rule causing service to go down?

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

Re: Unique identity to identify elements in TM1 subsetEditor

Re: Configuring rights

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

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

Re: Dynamic query argument in TI...

Re: Why IBM should sell off TM1 by James Wakefield

Re: TM1 Perspective Vs Pax