N/APosted on - 07/18/2011
I am using PowerOLAP in Assigning a Fact Data security for our company’s database. I encountered a problem when I was assigning a Fact Data Privileges through the Cubes dialog box. See the attached error message.
After I selected a Users or a Group and selected an Access level, I clicked OK where I returned to the Fact Data Security Rules dialog box eventually. I also typed a semi colon (;) at the end, to end the expression. When I clicked the Check button to scan the expression for errors, this error message popped up:
There is no syntax errors in the security rules
How can I remove this error dialog box on my screen? Can someone provide me a good solution?
Syntax Error on Power OLAP
The error message that you are seeing is just to tell you that there are no errors. When this dialog appears you need to click OK. (If any errors have occurred you will get a message telling you where the error occurred and how to fix it). When the fact data security rules that you want are finished, you need to click OK in the dialog box again. Then click OK in the cubes dialog box.
When this is done then all Fact Data Security Privileges have been assigned to users and groups. Hopefully when you follow the instructions above, it will fix your problem. If you are trying to stop the dialog box from appearing, then unfortunately you cannot do this.