You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Incorrect value in smartview when retrieving value for a member with member formula

Received Response
27
Views
13
Comments
edited Aug 2, 2018 2:36AM in Essbase 13 comments

Summary

Incorrect value in smartview when retrieving value for a member with member formula

Content

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

(([YTD], [Day].CurrentMember)-([Apr],[D30],[YTD]))

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.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!