Skip to Content
avatar image
Former Member

MIN and MAX Dates in Lumira Desktop 1.28

Jul 15, 2017 at 07:42 PM | 138 Views

Hi All,

I am trying to find out the Min and Max dates from the date dimension in my data set but I could not find the aggregate function to do that. I can see the below notes in Developer Guide for Lumira 1.28 which is what I am using (Desktop version)

https://help.sap.com/doc/businessobject_product_guides_vi01_en_lum_128_user_en_pdf/1.28.0.0/en-US/lum_128_user_en.pdf

(Page 73)

Any help is appreciated, thank you!

Thanks,

Anil

capture1.jpg (32.4 kB)
capture2.jpg (74.7 kB)
SAP Lumira, desktop edition
SAP Lumira
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • avatar image
    Tammy Powlas
    Jul 15, 2017 at 09:18 PM

    Anil - please see this thread: https://archive.sap.com/discussions/thread/3895484 - I don't know if it will work with 1.28 - if not, please try to upgrade to 1.31

    Good luck

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member
      Jul 17, 2017 at 08:52 AM

      Hello Tammy,

      The way this works is as below.

      1. Click on the settings (options) icon from a dimension object (Date in my case)
      2. Choose Create Measure
      3. Notice the new object created under Measures section.This should default to Count(All).
      4. Click on the settings (options) icon on this new measure and choose 'Change Aggregation' and use the required (min/max) from here
      5. Rename the new measure as needed

      Thanks,

      Anil

  • avatar image
    Former Member
    Jul 17, 2017 at 08:52 AM

    The way this works is as below.

    1. Click on the settings (options) icon from a dimension object (Date in my case)
    2. Choose Create Measure
    3. Notice the new object created under Measures section.This should default to Count(All).
    4. Click on the settings (options) icon on this new measure and choose 'Change Aggregation' and use the required (min/max) from here
    5. Rename the new measure as needed
    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jul 17, 2017 at 08:53 AM

    The way this works is as below.

    1. Click on the settings (options) icon from a dimension object (Date in my case)
    2. Choose Create Measure
    3. Notice the new object created under Measures section.This should default to Count(All).
    4. Click on the settings (options) icon on this new measure and choose 'Change Aggregation' and use the required (min/max) from here
    5. Rename the new measure as needed
    Add comment
    10|10000 characters needed characters exceeded