Calling dimension from different model

[aditya_ponnala]

Hi I have below requirement. Requirement: Generate a report by filtering on a dimension property (in other model say model 2). I tried using VB and command EA.OpenFilteredMemberSelector(connection, "COSTCENTER", "", , True) and overriding the values in current model (say model1). However it opens a pop up for the user to select members and I am not able to pass member property to the command. Model 1 is where EPM report is generated Model 2 is where the dimension is.

[aditya_ponnala]

Clarity on requirement: There are two models Model 1: Uses Dimension: COSTCENTER to do some functions in Script but COSTCENTER is not the dimension in Model 1 Model 2: Has no data but has dimension: COSTCENTER. In other words, COSTCENTER is a dimension used to handle some intermediate functionality. It is added to model 2 just to facilitate this reporting. Now as a functionality in Model 1 is handled using Dimension: COSTCENTER even though it is outside the dimension, we want to use the same dimension while reporting the data. Say this Dimension: COSTCENTER has only 3 cost centers on which we want to report. When report is generated out of Model1, it should only use those 3 cost centers in Dimension: COSTCENTER. Yes, cost centers is also a valid dimension in Model 1 with a different dimension name. Also this cost center dimension in Model 1 has 1000's of cost centers. Hi Dinesh, I don't why I didn't try the hidden report option. That seems very plausible solution. I will try and keep you all posted. Thanks! Hence I said, override cost centers in Dimension: COSTCENTER from model 1 with 3 cost centers in Dimension: COSTCENTER in Model 2. Hope it now makes sense.

[former_member186338]

Sorry, but why do you need to use second model with extra COSTCENTER dimension?? Why you can't select COSTCENTER1 from the first model?? The setup looks strange...

Do you have some property in second model for dimension COSTCENTER... or??

[former_member186338]

"Generate a report by filtering on a dimension property (in other model say model 2" - sorry but the requirement is not clear!

[Former Member]

Hi Sivaram,

Could you please explain this with an excel layout? Not able to understand the requirement exactly.

Regards,

JP

[dinesh_veluru]

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 override

and use the Before_refresh function , refresh the hidden report first and then refresh the Main report

Thanks,

Dinesh.V