0

[Publication] Page repeat children of filtered/selected member

Hello,

 

I am wondering if it is possible to filter a Publication and having a page repeater export the children of the filtered member.

 

For example: I would like to export a publication for Europe, then a specific page should export all the countries in Europe. And the same would also work for any other region such as Asia or Africa. 

 

My data source is an OLAP cube.

6 replies

null
    • "making the sophisticated simple"
    • AviPerez
    • 3 yrs ago
    • Reported - view

    Yes, its possible. But it will be may be a little complicated in OLAP - depending on your cube design.

    The way to get this to work, is to take your original OLAP hierarchy and show the 2 level attributes independently in the cube (they are already there, they just need to be set to "visible". A 2 minute exercise). Then, use the lower attribute to drive the page repeater; while using the upper attribute to drive the publication slices.

    Using the a single hierarchy (with multiple levels) to drive both actions will probably not work.

      • Douglas_Karlstedt
      • 3 yrs ago
      • Reported - view

      Avi Perez Thank you for your reply Avi. I talked to IT, they will not be showing the attributes. I do indeed have a single hierarchy with multiple levels. Would it be possible to solve this by connecting the Publication filter to the page repeater filter which has a set of something like .currentmember.children in the same dimension? 

    • "making the sophisticated simple"
    • AviPerez
    • 3 yrs ago
    • Reported - view

    Let us take a look and see what we can come up with. Do you have access to the yellow data modeling tools?

      • Douglas_Karlstedt
      • 3 yrs ago
      • Reported - view

      Avi Perez Yes I do believe I have that. Is it the one with Direct Model, Model Lite and Model Pro?

    • "making the sophisticated simple"
    • AviPerez
    • 3 yrs ago
    • Reported - view

    Douglas

    There are 2 solutions. 

    1. The first involves upgrading to 2020.15 - where we added a tweak to the page repeater engine that will allow you to cascade the selection using parameters and lists. Here, you would first create a parameters of the regions. Next, create the inner list of countries that is filtered using a "nonempty" filter and the region parameter. After that, add a region list slicer (you could reuse the region parameter again) as the publication slicer. Then create the page repeater with the country list as the slicer. When you wire up the region slicer into the country slicer, you will see the option to set its parameter. And that's it. the rest works.
    2. Another technique, involves you creating your own data model with 2 columns in it: regions and countries. To keep it easier for the next part, make sure the names are EXACTLY the same as the cube's regions and countries. Now use the regions in your own model to build the publication slicer. Use the countries in your own model to build your page repeater slicer. They will auto cascade. Last, use the model mapping to wire up the values in your own model to the cube's dimensions so that they interact properly. And that's it. the rest works.

    #1 is better if you can get the upgrade. #2 is not a bad stop gap until you upgrade.

      • Douglas_Karlstedt
      • 3 yrs ago
      • Reported - view

      Avi Perez I tried your first suggestion and it works great! It even let me set the list to the children of my parameter. This means that I can select different hierarchies in my publication filter (e.g. Europe or Nordic or Sweden) and then repeat the children of that member. This is great because now I can have one publication for multiple people with different areas of responsibility.

       

      Thanks a lot Avi!

Content aside

  • Status Answered
  • 3 yrs agoLast active
  • 6Replies
  • 47Views
  • 2 Following