Let's assume that user can select a single CATEGORY member in Data Manager prompt (for example. using PROMPT COMBOBOX DM PROMPT(COMBOBOX,…) behavior in BPC NW 10 and 7.5). You want to execute logic depending on CATEGORY member: some logic for ACTUAL,...
Currently, if I alert some post as SPAM (especially blog comment with SPAM link inside comment) it may take more then one day to react. And during this period spammer will continue adding SPAM.
My proposal is that if there is an alert with "SPAM" r...
You need to properly initialize epm object!Please look on my sample code: https://blogs.sap.com/2019/06/24/bpc-nw-10-vba-function-to-get-bassomeparent-dimension-members-list/
Find in the row can be also replaced with array of row check (just make the row long enough). Same option to find last row - copy column with enough rows to array and search for empty cell.Range to array is extremely fast and array loop is also fast....