Skip to Content
0

What EPM function to use

Mar 09, 2017 at 11:05 AM

55

avatar image

image.pngHi ,

I have created an input form and I entered data for every activity. I would like to know what EPM function to use in ordre to display the total of activity in a Excel cell

image.png (19.1 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

6 Answers

Vadim Kalinin Mar 09, 2017 at 11:27 AM
0

Create EPM report with Activity in the row. What is the issue? Please read basic help on EPM!

Show 2 Share
10 |10000 characters needed characters left characters exceeded

CAN i have an example please?

0

"Please read basic help on EPM!" - there are a lot of examples:

https://help.sap.com/viewer/ec68e48b18a44a49abb12b8ee8ae306f/10.0.28/en-US/f9bed6696faf1014878bae8cb0e91070.html

P.S. Link corrected

0
Priyanka Jagtap Mar 09, 2017 at 12:02 PM
0

There is no EPM Function which totals/sum up the data. Use Excel function (=SUM) to do so...using a local member.

Show 3 Share
10 |10000 characters needed characters left characters exceeded

But if you look on the screenshot you will see that TOT_ACT is a parent! No function nesessary :)

0

If it's required to get immediate sum before posting data to the cube - then Edit Report -> Options: Calculate Parents in Hierarchies

0

My bad Vadim! I missed the attachment..;) Yes if heirarchy is present then no need of any formula!

0
Serge Bambara Mar 10, 2017 at 09:21 AM
0

Ok. If I use Excel function (=SUM), can I have an example of this ? What hierarchy to use PARENTH1 or ID member?

Show 1 Share
10 |10000 characters needed characters left characters exceeded

"What hierarchy to use PARENTH1 or ID member"

Hierarchy is PARENTH1, what do you mean by ID???

0
Serge Bambara Mar 10, 2017 at 09:32 AM
0

FOR PARENTH1=TOT_ACT of the activity i will choose

Show 1 Share
10 |10000 characters needed characters left characters exceeded

Sorry, but not clear!

"FOR PARENTH1=TOT_ACT of the activity i will choose"???

0
Serge Bambara Mar 10, 2017 at 10:28 AM
0

For example I want to display the total of amount entered fir the activity with ID 1 in a cell, what can I do?

Share
10 |10000 characters needed characters left characters exceeded
Serge Bambara Mar 10, 2017 at 11:01 AM
0

Hello, I want to display the total of amount entered for the activity with ID 1 in a cell, what can I do?image.png


image.png (19.1 kB)
image.png (19.1 kB)
Show 1 Share
10 |10000 characters needed characters left characters exceeded

And what is the issue???

Just select in the report row axis ID 1 for Activity dimension

Please start reading help! Unfortunately I will have to alert moderator on your questions...

0