Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

Question

Hi all,

I got problem when i applied row security for my data.

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 23004] Invalid request: Subtotal GROUP BY clause cannot contain an aggregate expression case when Rank([FILTER(PO Amount:[DAggr(Fact - Purchasing - Order.PO Amount)] USING Dim - Business Unit.Key Id = VALUEOF(NQ_SESSION.MNS_COA) or '-999' = VALUEOF(NQ_SESSION.MNS_COA)) desc] ) < 11 then Dim - Supplier.Supplier Number || ' - ' || Dim - Supplier.Supplier Name else 'Others' end . (HY000)

This error just appear when i used account applied row security.

Can anyone help me!

Zoe.

3394405 · Answer

Hi Gianni Ceresa,

Thank you for your attention to my issue.

"Row security" - I mean row-level security. I need to limit data that another users can see. 
The first I defined Session Variable Initialization Block to hold the company code that the user is allow to see, and then I filter data of DIM/FACT using the Identity Manager dialog in RPD.

Please tell me if you have any idea to resolve this error.

Thanks

Gianni Ceresa · Answer

Hi Zoe,

Could you please add few more details on how/where did you setup "row security" and how does it look like?