Skip to Content
0

BPC NW 10 - EPM Excel : No total with the indicator date

Jun 06, 2017 at 09:48 AM

38

avatar image

date-total.png

Hello,

Version : EPM : version 10.0 SP23 Net 23

I created a report with the EPM Excel.

Details of customizing of report

rows : I assign the 3 member : Segment A,B and C with the hierarchy 'Total' for the dimension SEGMENT

columns : I assign one member : date for the dimension 'Indicator'

I managed the view format for the dimension indicator and assign the format 'date' and data validation ' See the file for miore details

Problems

BPC sums the dates. I don't want that the values of dates sums : 22:12/2369 in 'total semgent4 . The target is to have 28/06/2017 for the total segment'

NB : I would like to keep the hierarchy 'total segment ' for the others calculation.

Question :

What is the solution so that BPC don't sum the date for the total segment

Regards

Bastien

date-total.png (42.4 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

3 Answers

Vadim Kalinin Jun 06, 2017 at 10:39 AM
0

"BPC sums the dates" - BPC sums integer representation of Excel dates :) Format dates as numbers and you will see...

And Total will always sum parents!

Not clear what date do you want to have in "Total" if segment dates are different...

You have to use local member instead of "Total" member.

Share
10 |10000 characters needed characters left characters exceeded
bastien wissler Jun 06, 2017 at 11:58 AM
0

Hi Vadim,

I want to have the same date in 'total' and the other segment.

The dates are always de same for all segment.

NB : the user inputs the same a date for all segment. With a local member with the property of the dimension Segment, it's difficult because I dont want ot use the process to create the maseter data on the fly.

Share
10 |10000 characters needed characters left characters exceeded
Vadim Kalinin Jun 06, 2017 at 12:28 PM
0

With local member you simply reference the cell in the first line. No property used.

Share
10 |10000 characters needed characters left characters exceeded