on 2019 Dec 19 12:22 PM
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.
Request clarification before answering.
@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!
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Still, requirements are not 100% clear...
In VBA you can use SAPSetFilter
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
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?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you Vadim,
is it readable to you now? Now I can have an answer please to my question? 🙂
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
57 | |
10 | |
9 | |
8 | |
6 | |
6 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.