Skip to Content
avatar image
Former Member

How to activate a standard query ?

Hi Guys,

              I am getting an error couldn't find query /0BBP_SCA_Q002

When I check in Query Monitor RSRT, I don't find it.

Looks like its not active.

How to activate a query ?

here is the error

Thanks

Sam

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

6 Answers

  • Jan 14, 2015 at 07:07 AM

    Hi Sam,

    Is this the case in all the Servers or its exists in DEV and not in QA/PRD.

    If its there in DEV then move the Query and Data Flow to QA/PRD using TRs.

    If its not there in DEV also then Install it as suggested by other Friends..

    regards

    SVU

    Add comment
    10|10000 characters needed characters exceeded

  • Jan 14, 2015 at 07:15 AM

    Hi,

    select the RSA1 ->  go to the business content -> select the qeury -> again select the qeury elements -> select the query -> select the the only grouping options only necsary objects.

    install query.

    check the messages in down.

    Thanks,

    Phani.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 14, 2015 at 08:49 AM

    Hi,

    Before activation query have you proper data flow?

    Based on your needs please install whole data flow.finally you can install query.

    in your case you need to install info cube/dso -  0BBP_SCA and related data source(0BBP_TD_SC_APPR_1).

    finally you can install query 0BBP_SCA_Q002.

    da

    BI content installations you can handle from BW server T code - RSA1-->BI Content.

    Grouping options - only necessary obejcts

    install - first simulate and later install in background.

    Thanks

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member Former Member

      Hi,

      Info cube also you need to find in bw only not in SRM.

      Ask your basis team and install required patches/SP or BI Content part which have SRM Related data sources/targets.

      Ask your BW functional team to know the required BI content versions which have SRM objects as well.

      Other wise with help of Cube or data source names, please find required BW patch/SP  at SAP market.

      Finally you can check(raise ticket) with Global SAP Support.

      Thanks

  • avatar image
    Former Member
    Jan 13, 2015 at 11:28 PM

    Hi Sam,

    since this a standard BI content, you need to goto RSA1 > BI content and find the query(0BBP_SCA_Q002) to install the query elements.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 14, 2015 at 12:38 AM

    Hi Sam!

    How say Sai.

    1) RSA1

    2) Business content

    3) Query elements

    4) Select your query

    5) Use Grouping (Only necesary objects)

    6) Install

    Regards,

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 14, 2015 at 07:04 AM

    Hi Sam,

    Please also check 0BBP_SCA is activated... If not, you need activate it and related objects in data flow too.

    Add comment
    10|10000 characters needed characters exceeded