Cognos Analytics

Cognos Analytics

Connect, learn, and share with thousands of IBM Cognos Analytics users! 

 View Only

  • 1.  Equivalent Analysis Studio Functionality

    Posted Fri May 24, 2024 12:27 PM

    Current version Cognos 12.03

    Report Studio has replaced Analysis Studio. Using Analysis Studio we could click on the cube title and the information panel would show the date and time the cube was built. I can't find an equivalent with Report Studio. This is very useful for report creators.

    Note: We have an automated process that replaces the old .MDC with the newly created .MDC file. We don't recreate the connection or publish a new package. Even if we did it would help, as neither of those show the true date of the created .MDC

    Any ideas?



    ------------------------------
    Trevor Fyfe
    ------------------------------


  • 2.  RE: Equivalent Analysis Studio Functionality
    Best Answer

    Posted Tue May 28, 2024 10:50 AM
    Edited by Austin Rexroat Fri May 31, 2024 11:39 AM

    You could try this report expression function... I personally haven't use this, so just giving something to try:

    CubeDataUpdatedOn ( dimension )
    Returns the date time that data in the cube was last updated. "Dimension" specifies from which cube to retrieve the metadata.
    ------------------------------
    Mark Karas
    Partner, Senior Principal Consultant
    PMsquare
    IL
    ------------------------------

    Original Message

    Current version Cognos 12.03

    Report Studio has replaced Analysis Studio. Using Analysis Studio we could click on the cube title and the information panel would show the date and time the cube was built. I can't find an equivalent with Report Studio. This is very useful for report creators.

    Note: We have an automated process that replaces the old .MDC with the newly created .MDC file. We don't recreate the connection or publish a new package. Even if we did it would help, as neither of those show the true date of the created .MDC

    Any ideas?



    ------------------------------
    Trevor Fyfe
    ------------------------------



  • 3.  RE: Equivalent Analysis Studio Functionality

    Posted Thu May 30, 2024 12:21 PM
    Edited by Trevor Fyfe Thu May 30, 2024 12:28 PM

    Thanks Mark,

    This function does work and produced the correct date and time.
    CubeDataUpdatedOn ( dimension)
    Note: The function below doesn't work
    CubeCreatedOn ( dimension )
    Returns the date and time when the cube was created. "Dimension" specifies from which cube to retrieve the metadata. If the dimension source is an IBM® Cognos® PowerCube (.mdc), the function returns a blank string because the initial creation date of a PowerCube is not maintained.
    Regards
    Trev



    ------------------------------
    Trevor Fyfe
    ------------------------------

    Original Message


  • 4.  RE: Equivalent Analysis Studio Functionality

    Posted Thu January 23, 2025 02:28 PM

    Hi all. 

    Here you'll find an online course for an easy transition from Analysis Studio to Cognos Reporting. The examples from the "Feature Comparison Document" are also demonstrated live in the course. For the next 5 days, it's available for free via this link:

    https://www.udemy.com/course/ibm-cognos-analytics-12-ad-hoc-reporting-with-cube-data/?referralCode=63888FA2D6B8A344045F&%3F&couponCode=BYE-ANALYSIS-STUDIO

    Jens



    ------------------------------
    Jens Bäumler
    Cognos Analytics, Planning Analytics and watsonx
    Apparo Group
    Germay
    www.apparo.de
    ------------------------------

    Original Message


Related Content