Virtual dimensions and Cognos BI

Post Reply
Catherine
Posts: 108
Joined: Wed May 20, 2009 7:30 am
OLAP Product: TM1
Version: 10.2.2 - PA
Excel Version: 2010
Location: Rennes, France

Virtual dimensions and Cognos BI

Post by Catherine » Mon Oct 21, 2019 1:38 pm

Hello,

We are wondering wether we are implementing "real" attributes dimensions ou virtual dimensions.

Do you know if Cognos BI is able to see and explore virtual dimensions ?

Thanks in advance

ascheevel
Posts: 90
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: 11.2
Excel Version: 2016

Re: Virtual dimensions and Cognos BI

Post by ascheevel » Mon Oct 21, 2019 2:35 pm

By virtual dimension you mean hierarchies right? Yes, those are accessible in Cognos BI when exploring data from a TM1 cube.

Catherine
Posts: 108
Joined: Wed May 20, 2009 7:30 am
OLAP Product: TM1
Version: 10.2.2 - PA
Excel Version: 2010
Location: Rennes, France

Re: Virtual dimensions and Cognos BI

Post by Catherine » Mon Nov 25, 2019 3:02 pm

Thanks for your answer.

I was also wondering if, on those virtual hierarchies, we can assign security ?

Let's imagine I create a virtual hierarchy allowing me to display and analyze my products by color. Is it possible to give some users access to only red products ?

ascheevel
Posts: 90
Joined: Fri Feb 15, 2013 5:49 pm
OLAP Product: TM1
Version: 11.2
Excel Version: 2016

Re: Virtual dimensions and Cognos BI

Post by ascheevel » Mon Nov 25, 2019 3:42 pm

Yes, you can set up hierarchy specific security within PAW. Watch out though if your element security for the dim has rules, you'd want rules that apply to consolidations to be made to be hierarchy specific lest they apply to all hierarchies.

Post Reply