Cube VIEW Security TURBO INTEGRATOR

Post Reply
mnasra
Posts: 136
Joined: Tue Aug 10, 2010 5:40 pm
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: EXCEL 2013

Cube VIEW Security TURBO INTEGRATOR

Post by mnasra »

I have a TI process creating data into a cube from a view from another cube (Actuals into budget of second cube).
Everything works fine. But my problem, is that the view for the TI is public.
I have users who read it, and save it with different data.
How can I secure these views made only for TI- so no one can see them, use them or delete them, or even try to read them (which gives them memory error anyway).

Thanks
Thanks
Micheline
User avatar
jim wood
Site Admin
Posts: 3961
Joined: Wed May 14, 2008 1:51 pm
OLAP Product: TM1
Version: PA 2.0.7
Excel Version: Office 365
Location: 37 East 18th Street New York
Contact:

Re: Cube VIEW Security TURBO INTEGRATOR

Post by jim wood »

As far as I know (based on earlier versions) there is no way of securing it. It has to be a public view. You could always assemble the view in the TI process or even assemble it in another process before running the copy. Then kill the view once the load is complete,

Jim.
Struggling through the quagmire of life to reach the other side of who knows where.
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
mnasra
Posts: 136
Joined: Tue Aug 10, 2010 5:40 pm
OLAP Product: Planning Analytics
Version: 2.0
Excel Version: EXCEL 2013

Re: Cube VIEW Security TURBO INTEGRATOR

Post by mnasra »

Oh- I never thought of assembling the view in the TI process-
THANKS
Micheline
Thanks
Micheline
User avatar
Steve Vincent
Site Admin
Posts: 1054
Joined: Mon May 12, 2008 8:33 am
OLAP Product: TM1
Version: 10.2.2 FP1
Excel Version: 2010
Location: UK

Re: Cube VIEW Security TURBO INTEGRATOR

Post by Steve Vincent »

Jim is (still) right - all TI views must be public, there is no way to hide them. Either name them so they fall at the end of the list of views (zPro_Blah) or as Jim suggested create the subsets and view as part of the TI itself. You can then destroy those objects after the TI has done what it needs to.
If this were a dictatorship, it would be a heck of a lot easier, just so long as I'm the dictator.
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
User avatar
Martin Ryan
Site Admin
Posts: 2003
Joined: Sat May 10, 2008 9:08 am
OLAP Product: TM1
Version: 10.1
Excel Version: 2010
Location: Wellington, New Zealand
Contact:

Re: Cube VIEW Security TURBO INTEGRATOR

Post by Martin Ryan »

There's an outstanding request from the community to rectify this as IMHO it's a pretty big failing for an industrial tool.

You might want to raise an enhancement request with IBM too. They might eventually pay attention to us.

Martin
Please do not send technical questions via private message or email. Post them in the forum where you'll probably get a faster reply, and everyone can benefit from the answers.
Jodi Ryan Family Lawyer
Post Reply