How to activate a standard query ?

[Former Member]

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

[RamanKorrapati]

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

[Former Member]

Hi,

     I don't find the query and Infocube under the BI Content in BW.

I don't find the Infocube 0BBP_SCA in SRM Source system.

Not sure what's missing or some note needs to be applied..?!

Thanks

Sam

[RamanKorrapati]

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

[KodandaPani_KV]

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.

[former_member202718]

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

[guang_li]

Hi Sam,

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

[fcorodriguezl]

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,

[former_member308471]

Hi,

Can we select multiple queries at a time to install?

[Former Member]

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.