I have set up a validation rule to report the entities that have been loaded but that are not at the bottom level of the ENTITY dimension.
For that, I added an account "+LevelNumber+" is Essbase ACCOUNT dimension that returns the current entity level number.
The rule is set as #ModeRule and the rule logic is "+|,,,,,,LevelNumber,,,,,,,,,,,,,,,,,,,,,|>0+"
However when the validation is executed upon "Check" in the workflow and the report is generated, it returns a "LOOKUP ERROR" in the report value column and each entity has the status of "Error".
The integration between FDM and Essbase works fine. I can browse Entities in Maps and I can import data into the Essbase cube target too.
But I can't browse accounts and entities in the validation editor.
Interesting point. No I haven't.
I just did and now I can browse Entity and Account and test my rule!
One thing I also had to do was to include all Essbase dimensions in FDM. I had excluded three of them and defined them in a load rule.