Hi All,This document is intended for beginners on housekeeping of Data change Audit.Why Data Audit feature has to be turned ON for models.Benefits:Keeps track of the data changes that have happened through various tasks (i.e input schedule, Data mana...
Hi friends it has been observed that we are not able to override the page axis with multi members by using cell reference. Below is the sample VBA code to achieve the same.Sample requirements:Dimension: Costcenter_test ---> Page axis cell ” B1”Dimen...
Dear Experts,Does the BPC audit report read data from both the regular audit tables and the archive audit tables?In other words, is it possible to report on archived audit data using BPC audit reports?Thanks,Dinesh.V
Dear Experts,I am searching for a VBA Macro command to launch the Report Action -> "Worksheet Generation" to generate multiple worksheets for the members in a dimension.Please advise.Thanks,Dinesh.V
Dear Sivaram,Can you please explain in detail with required screenshots please.How about creating an hidden report for model2 to get desired property values of the dimension and use it in your main report by dimension overrideand use the Before_refre...
Hi Sandra,1) I would suspect that the other user has different DAP access. please compare the sequence of the members in the epm context pane in the excel for both the users.the epmmemberoffset will provide the output as per the sequence.2) "clear th...