Creating subset and views in TM1 Java API

[sushanti]

Hi,

Can anybody please put light on coding in Java API to create subset and Views in TM1 ?

Thanks and Regards,
Sushanti

[sushanti]

Thanks for viewing my post. I have got the code from sample directory we get along with TM1 installation.

[Steve Rowe]

Thanks for posting an update sushanti, it's not an area that many people get involved in. It would be interesting to know what your planning on using it for?
Cheers

[sushanti]

Basically, the application we have created are having about 30 cubes. The elements in the dimension of these cubes are getting updated dynamically through a database using process.

I have written a java code which provides security to different groups. This security is very granular upto element level. E.g based on user's role he will get access to specific cubes and element. Now this code is fine until users use Architect. When workflow is coming into the picture we have to create many Views from him according to his Role. so that these views become tasks in Workflow. To create views in java API, that many subsets are also required.

This has become complicated and time consuming. Now we have moved to TM1 9.5. Lets c how we design the same there.

[lotsaram]

TM1 already provides its own on board ETL and scripting tool. Why would you not use Turbo Integrator to create the subsets and views (and set security for that matter)?

It would make your life a whole lot simpler!

[sushanti]

Hi,

TI Process cannot create Views or subsets based on database values..

Please put some light on it.

Regards,
Sushanti

[Steve Rowe]

Hi Sushanti,

You can certainly reference TM1 and ODBC type DBs from TI, what database do you need to view to drive your process?

Cheers

[sushanti]

Hi,

Thanks for replying..Yes I did find SubsetCreate and ViewCreate methods in Process Function Names.. Using this scripts can be written in prolog...

I am connecting with Oracle database.

Regards,
Sushanti