I restrict few main accounts for users using record level security, its working. But in trial balance form and reports its not working.
For ex. I restrict 6* series main account for users, but in trial balance form and in report its showing.
How to restrict this 6* series main account in trial balance form and in report?
Have you tried by applying it on DimensionAttributeValueCombinatoin?
I would also suggest using Extensible data security (https://technet.microsoft.com/en-us/library/hh272123.aspx).
I created a query with range filter and applied on Security policy, its working in Main Account but not in Trial Balance form,
Tmp tables are not workingin XDS concept.
So do you added this table?
DimensionAttributeValueCombination i added in XDS - security policy at that time its worked in Trial Balance form, but the problem is its restrict 6* for all legalentity
so i prefer to go with record level security and specified, but its not restrict the value
now what's the solution for this (Main account working fine).