Set Data Security in FM model for Cognos 8 Reports

[Naven]

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

[MFGF]

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.

[Naven]

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

[MFGF]

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.

[Naven]

Thks MF :)...I will try and revert...