Skip to Content
avatar image
Former Member

MIN and MAX Dates in Lumira Desktop 1.28

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

3 Answers

  • 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

      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