Help with proper usage of profile wise security

Data Security
, ,
#1

Hello Helical Insight,

I am using Helical Insight enterprise edition 4.0. I am trying to implement metadata security using the profile attributes

Execution Type : conditionIf

First Way
Filter: [MOS].[dbo].DataReport.CompanyId = ${profile[1]}.value

Second Way

Filter: [MOS].[dbo]. DataReport = ${profile['patentCompanyId']}.value

Third Way

Filter: [MOS].[dbo]. DataReport = ${profile['patentCompanyId']}

I tried to get a profile value with the above way but I can’t get it. It’s throwing an exception in the report (Error: SQLServerException: The multi-part identifier “.value” could not be bound.)
How to apply correctly?

Thank You,
Netta.

#2

Hello Netta,

Please use something like this in the filter and try.
[MOS].[dbo].DataReport.CompanyId = ${profile[\'patentCompanyId\']}

Thank You,
Helical Insight