Incorrect value in smartview when retrieving value for a member with member formula
SummaryIncorrect value in smartview when retrieving value for a member with member formula
I have a strange issue, request someone to help me .
There is a view MTD , member formula for this is :-
WHEN [Period].CurrentMember is[May] THEN
In the smartview if I select intersection as MTD and all the account dimension members, the value is wrong (screenshot 1).
Whereas if I select a few of the accounts and view the MTD, the calculation and value are correct (screenshot 2).
The calculation looks proper in the second case and when i enter some account in the intersection. But the calculation goes wrong if I select all the accounts or children of the parent member or all base members of the parent member from the member selection option in essbase tab in smartview.