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
Cube VIEW Security TURBO INTEGRATOR
-
- 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
Thanks
Micheline
Micheline
- 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
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.
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
Go Build a PC
Jimbo PC Builds on YouTube
OS: Mac OS 11 PA Version: 2.0.7
-
- 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
Oh- I never thought of assembling the view in the TI process-
THANKS
Micheline
THANKS
Micheline
Thanks
Micheline
Micheline
- 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
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
Production: Planning Analytics 64 bit 2.0.5, Windows 2016 Server. Excel 2016, IE11 for t'internet
- 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
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
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
Jodi Ryan Family Lawyer