Hi All,
I am using TM1 application package to create BI reports.
When metadata is imported into FM cubes are imported,there is no scope for any changes.
I am not able to set data security or apply any filters also.
Could anyone tell please guide me on how to achieve this functionality.
Thanks,
Naveen
Hi,
You're correct in that for cubes, there is no specific modelling that can be done in Framework Manager. The security needs to be defined within the TM1 cube - in Architect or Perspectives.
Regards,
MF.
Hi MF,
Thanks for your reply.
So if we define security in TM1 cubes will inherit these properties .
Consider a scenario where a user has access to a particular geography and security is defined for the geography element in TM1.When the same user executes the report in Cognos Connection, data related to him will be displayed.
Am I right?, Please confirm.
And any integration work to be done for the security to work?
Regards,
NAveen
Yes, but the caveat is that Cognos 8 must be using the same security provider. I'm guessing this is Access Manager?
Section 9 of the TM1 Operations Guide (Cognos Access Manager Authentication) covers how to set this up. There is a set sequence of steps to go through and you need to follow them exactly. However, I did find an discrepancy in one of TM1S.CFG statements on page 9-5 that I think you may need to change.
The manual says
CAMPortalVariableFile=templates\ps\portal\variables_TM1.xml
I had to change it to this to get it to work
CAMPortalVariableFile=\portal\variables_TM1.xml
Not sure if it's specific to how I have C8 set up locally or if it's an glitch in the manual.
MF.
Thks MF :)...I will try and revert...