Cognos Analytics

Expand all | Collapse all

AMA: Shaping the future of smart data preparation in Cognos Analytics with Omar Khan

  • 1.  AMA: Shaping the future of smart data preparation in Cognos Analytics with Omar Khan

    Posted Wed May 13, 2020 10:54 PM
    Edited by MOHAMMED OMAR RASHEED KHAN Wed May 13, 2020 10:55 PM
    IBM Community's Virtual User Group Day is right around the corner!


    I'm Omar Khan, Offering Manager, Cognos Analytics, IBM, and I will be leading a technical session on May 19, from 3-3:30pm ET: 
    ______________________
    Shaping the future of smart data preparation in Cognos Analytics  
    It's easier than ever to start transforming ugly, complex data into beautiful, simplified visuals. In this session, we will showcase the product's latest capabilities and all the exciting features coming soon to data modules.  
    ______________________
    Please share any thoughts or questions here in the thread, and we'll make sure this is available to you after the event so you can watch the replay and share your questions directly with me. In the meantime, would love to hear a little bit about yourself and what you'd like to get out of our User Group event. Drop a line in the thread below!


    Register for Virtual User Group Day | May 19-20: https://ibm-usergroups.bemyapp.com

    Get more information about the Planning Analytics and Cognos track: ​
    IBM Planning Analytics and Cognos Community Day

    You can find all of the AMA threads
    here

    ------------------------------
    MOHAMMED OMAR KHAN
    Offering Manager
    IBM Cognos Analytics
    ------------------------------


  • 2.  RE: AMA: Shaping the future of smart data preparation in Cognos Analytics with Omar Khan

    Posted Wed May 20, 2020 01:27 PM
    Hello Omar, 
    My client wants to join data from two different Framework Manager packages within one query in a report. Report Authoring in Cognos Analytics does not allow that. Data modules on the other hand can have multiple FM packages as a source. Can I integrate two FM packages in one data module, so when using this data module as a report source I will be able to build queries joining data from these two packages? If so, are the any known limitations to this approach?
    Kind regards,
    Mark
    ----------------------------
    Mark Nowack
    Analytics Specialist
    Fiducia & GAD IT AG

    ------------------------------
    Mark Nowack
    ------------------------------



  • 3.  RE: AMA: Shaping the future of smart data preparation in Cognos Analytics with Omar Khan

    Posted Wed May 27, 2020 04:38 PM

    Hi @Mark Nowack,

    I was on vacation late last week so thanks for your patience for the reply!​

    When using FM packages as a source in the data module, you'll notice that we disabled a lot of the functionality. This is because we want to avoid the inelegant modeling structures that might be created if you model in FM, then further model it in data modules and then possibly in reporting. However, in data modules, there is some lightweight modeling that you can do when you create Views on the tables based on FM packages. You may be able to join two views and get the results you want in reporting but that may still not be optimal for performance. Our recommendation would be to create those joins in FM for the best performance.

    Best Regards,



    ------------------------------
    MOHAMMED OMAR KHAN
    Offering Manager
    IBM Cognos Analytics
    ------------------------------



  • 4.  RE: AMA: Shaping the future of smart data preparation in Cognos Analytics with Omar Khan

    Posted Wed June 03, 2020 04:58 AM
    Hi Omar,
    what does it mean exactly: "you'll notice that we disabled a lot of the functionality."? We are using version R11.1.3. It means that some features that work now will stop working once we upgrade our version?

    Thx

    ------------------------------
    Josef Minarik
    ------------------------------



  • 5.  RE: AMA: Shaping the future of smart data preparation in Cognos Analytics with Omar Khan

    Posted Thu May 21, 2020 08:56 AM
    I was not able to attend this event. Will recordings be available?

    Thank you,

    ------------------------------
    Wendi Lewis
    ------------------------------



  • 6.  RE: AMA: Shaping the future of smart data preparation in Cognos Analytics with Omar Khan

    Posted Wed May 27, 2020 04:51 PM
    Hi @Wendi Lewis,

    You are definitely in luck! All the sessions in the Cognos and Planning Analytics ​​were recorded and are available for replays for 90 days starting from May 19th. You can find them here - https://community.ibm.com/community/user/businessanalytics/blogs/stephanie-freyer1/2020/05/01/ibm-planning-analytics-and-cognos-community-day

    Best Regards,

    ------------------------------
    MOHAMMED OMAR KHAN
    Offering Manager
    IBM Cognos Analytics
    ------------------------------