0ic_c03 in this some queries are missing

[Former Member]

I activated cube 0IC_C03 and installed  the cube as only necessary objects and installed the queries in same way successfully .But when i wanted to see in query designer  some

queries are missing .The below queries list is missing

Days' Supply	0IC_C03_Q0018
Inventory Aging	0IC_C03_Q0021
Inventory Turnover	0IC_C03_Q0017
Stock Overview - extended	0IC_C03_Q0022
Warehouse Analytics - Obsolescence and Variance	0IC_C03_Q0025
Warehouse Stock Analytics – Inventory Turnover	0IC_C03_Q0024

The remaining queries will be fine.I am able to open in query Designer.

Presently i am using BI 7.0 support pack  is 27 and BI content 9.Please help me on this i will assign points to the helpful answers as well

[Former Member · Accepted solution]

Ram,

Goto MetaData Repository and check whether the missing queries are present in the system for that infocube. If not When installing infocube from Business content use the option Dataflow afterwards and see if all the related queries are checked and install it. After this u should be able to find the missing ones.

Regards,

Rakesh

[anshu_lilhori]

Hi,

DID you try searching these queries in qeury list under transportation connection.

You can search for it there and then install the same.

Hope it helps.

Regards,

AL

[Former Member]

I have done installation  from Business content the cubes and queries in DEV. I am unable to see it in the DEV system itself " when i am trying to check it from query designer and RSRT as well"

[anshu_lilhori]

HI,

Go to RSA1----BI content----Query Elements---Query----Select objects----give the Query Technical name--find

Once you get it then transfer and install.

Hope it helps.

Regards,

AL