cancel
Showing results for 
Search instead for 
Did you mean: 

Measure Filter Members using VBA

mosaid
Explorer
0 Kudos
1,279

Hello SAP AfO Gurus.

Today I need your quick help please as I am trying to automate the functionality "Filter Members" (to hide/show measuers/columns instead of dimensions) using VBA.In my AfO report.

I have 2 queries: sheet (or query) 1 with Fiscal perdiod and measures M1, M2, M3 and is summary data let's say, and another sheet (or query) 2 that has document level data (Document num, Document item, CC, PC…) and which should only show one measure at time (M1 or M2 or M3) based upon the KPI from sheet1 the user has clicked on to move to sheet 2. I am using DoubleClick event to move from sheet 1 to sheet 2 this event is working fine.

I really appreciate any help.

Thank you and looking forward to reading you.

Accepted Solutions (1)

Accepted Solutions (1)

mosaid
Explorer
0 Kudos

@vadim.kalinin : impossible is a word that exists only in dictionnary of small minds. In IT everything is possible, there is Always a way. If somebody needs to figure out how to do it please leave a comment here. Problem resolved!

former_member186338
Active Contributor
0 Kudos

It's really a very strange idea to provide a pseudo answer without an answer and to accept it. Unprofessional!

Answers (5)

Answers (5)

mosaid
Explorer
0 Kudos

Ok no worries, not everybody can find a solution to Something I couldn't manage to find myself :))

Thank you for your time anyway.

Merry christmas

former_member186338
Active Contributor
0 Kudos

And sometimes there is no answer at all: Like: it's impossible 🙂

Merry Christmas

former_member186338
Active Contributor
0 Kudos

Still, requirements are not 100% clear...

In VBA you can use SAPSetFilter

https://help.sap.com/viewer/ca9c58444d64420d99d6c136a3207632/2.7.1.0/en-US/f27134636c9b1014bf2c9a7eb...

mosaid
Explorer
0 Kudos

Thank you Vadim.

What is not clear to you? I want to filter on my KPIs using VBA, the same SAPSetFilter do for dimensions, but this time for my KPIs.

I tried it SAPSetFilter before posting here.

If you have any idea on how to use your function on top of measures and not on top of dimension, I will be more than thankful 🙂

Looking forward to reading you.

Regards

former_member186338
Active Contributor
0 Kudos

mosaid

Sorry for misunderstanding! No idea!

mosaid
Explorer
0 Kudos

Hello Vadim,

I think you got the screeshots and post is now readable to you, I hope.

So you could resolve to answer my question or you are unable?

mosaid
Explorer
0 Kudos

Thank you Vadim,

is it readable to you now? Now I can have an answer please to my question? 🙂

mosaid
Explorer
0 Kudos

Thank you very much Vadim. Here they are. Please let me know if you have any clue on how to fulfill that requirement 🙂