Cognos Analytics

Cognos Analytics

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


#Product
#Analytics
#CognosAnalytics
#Analyticstools
#TechXchange Partner
#TechXchange Session
#TechXchange Presenter
#AI
 View Only
  • 1.  Framework Manager SQL (RSF prefix)

    Posted 10/03/22 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 10/04/22 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
    ------------------------------



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

    Posted 10/04/22 02:13 PM
    Thanks Henk!! That terminates the repetitive loop in my brain wondering where the RSF acronym originated...

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