Cognos Analytics

Cognos Analytics

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

 View Only

  • 1.  Framework Manager SQL (RSF prefix)

    Posted Mon October 03, 2022 03:49 PM
    Hi all,
    I'm working in Framework Manager (v11.2) with a DQM model and testing a fact query subject with DQM Usage property set to "Summary Query". In the Test Results dialog box, Query Infomation tab (IBM Cognos SQL), i'm seeing some queried items labelled with a "RSF_" prefix. What do the RSF initials stand for?
    Just really curious *^_^*
    Thanks,
    Syd

    ------------------------------
    Syd Shewchuk
    Trainer / Consultant
    Newberg, OR
    ------------------------------

    #CognosAnalyticswithWatson


  • 2.  RE: Framework Manager SQL (RSF prefix)
    Best Answer

    Posted Tue October 04, 2022 10:01 AM
    Hello Syd,
    I'm not sure what you're going to get out of this info, but here it is:
    RSF prefix stands for RQPQuery Summary Filter - it is the subquery for summary filter
    RQPQuery stands for Relational Query Planner

    Enjoy !

    ------------------------------
    Kind regards,
    Henk Cazemier
    ------------------------------

    Original Message


  • 3.  RE: Framework Manager SQL (RSF prefix)

    Posted Tue October 04, 2022 02:13 PM
    Thanks Henk!! That terminates the repetitive loop in my brain wondering where the RSF acronym originated...

    ------------------------------
    Best regards,
    Syd
    ------------------------------

    Original Message