This week I have been working on demo content for upcoming webcast on working with EPM Cloud content in OAC DV and BI Dashboards. And I ran into issues where members in my Account Dimension where not showing up in Analysis or Filters so I thought I would share what I found.
First I had imported my EPBCS app with the pre-built modules into my Physical Layer.
I moved the whole app to the BMM Layer
When I looked at the Business Diagram I see the 9 Cubes
To create the Presentation Layer I righted clicked and selected Create Subject Area for Logical Stars and Snowflakes
Voila, I have 9 subject areas.
The work I want to do is with Employ demographics so I will be working with the EPBCS - OEP_REP subject area. I started working in DV and setting a filter on Account. I quickly noticed I was not finding the Account I was interested in so I switched to Classic Home and created an analysis with the Account Hierarchy Column.
I am not seeing the Account structure that is what is in REP cube.
So back to the RPD.
This time I brought each cube into the BMM layer individually.
And when I went back to Analysis of the OEP_REP and checked the Account Hierarchy
And it matches the cube.
So something is happening in the RPD when working with multiple cubes in a BMM Layer object.
My recommendation...Import the App and create individual BMM Layer objects per cube.
