Skip to Content

BusinessObjects Cloud (BOC) - Reporting - Dimension filter on property

Hi,

I would like to create a report filtering the dimension in row (or column) using a property of the dimension. Is this feasible?

Thank you

Ivan

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Aug 21, 2017 at 08:37 PM

    Hi Ivan,

    Currently you cannot filter out data by properties. This has been already suggested here: https://ideas.sap.com/D40002 (please vote it up ).

    You can create restricted measures in your account dimension referencing properties though (ProductType is a property / attribute of the PRODUCTGROUP dimension)

    RESTRICT([H111100],[d/PRODUCTGROUP].[p/ProductType]="A")

    or you can create restricted measure in the story editor via the calculations dimension but you need to manually select your dimension values:

    Add comment
    10|10000 characters needed characters exceeded

  • Mar 24, 2017 at 06:03 PM

    Hi Ivan,

    I am not 100% sure if I understood the question, could you please give more details using an example?

    If you have an attribute dimension or property for another dimension, you can use it to filter. For example, using the "Full Name" of a "City ID".

    If you want to filter depending on the value in that particular dimension, for example, for "City ID" starting with "00", you can create a new calculation.

    Regards,

    Julian

    Add comment
    10|10000 characters needed characters exceeded

    • Hi Ivan,

      Thanks for this clarification. If that is the case, it should be simpler. A filter can do that job.

      In your model I assume that this property that can be set to "x" is a Dimension. Then, you should be able to filter using a simple Input Control and selecting only the value "x" from your Dimension.

      Here, using the Sample Demo I set a filter when cities are only San Diego y Sacramento:

      If you have a Dimension that has values such as "discounted", "retired", etc. You can filter, display and aggregate only those records.

      Let me know if this answer your question.

      Cheers,

      Julian

      input-control.png (31.3 kB)