0SM_CCLM Queries do not return correct data

[IanStubbings]

Hi

I've been testing my queries on various cubes and not having much success. The ATC ones work ok, The UPL ones tend to show no data or time out and the 0SM_CCLM queries show a 0 count always.

On researching the 0CM_CCLM ones a bit more with a colleague, he suggested that the 0SM_CCLRC key figure should have a count in it. I found out that previously that was in error in SP07 and it was amended via note 1779251 - Key Figure 0SM_CCLRC does not exist in the Cube 0SM_CCL and noticed that when the key figure was added, it was done so with a constant value of 1.

My question therefore is whether there is a problem with this cube also and the 0SM_CCLRC key figure does not have a constant value of 1 making the summation impossible and hence all my totals are 0 for all queries on this cube.

Thanks

Ian

[IanStubbings]

Hi

I've been testing my queries on various cubes and not having much success. The ATC ones work ok, The UPL ones tend to show no data or time out and the 0SM_CCLM queries show a 0 count always.

On researching the 0CM_CCLM ones a bit more with a colleague, he suggested that the 0SM_CCLRC key figure should have a count in it. I found out that previously that was in error in SP07 and it was amended via note 1779251 - Key Figure 0SM_CCLRC does not exist in the Cube 0SM_CCL and noticed that when the key figure was added, it was done so with a constant value of 1.

My question therefore is whether there is a problem with this cube also and the 0SM_CCLRC key figure does not have a constant value of 1 making the summation impossible and hence all my totals are 0 for all queries on this cube.

Thanks

Ian

[RiabovAleksandr]

hello Ian,

which query did you use?

I'll try it in my system

[IanStubbings]

Hi Alexander

0SM_CCLM/0SM_CCM_CREATED_OBJECTS_YEAR is one example.

[IanStubbings]

Hi Alexander

Just found note  2121937 - CCM Report Queries returns 0 Key Figures.

Would that be correct rather than changing the cube itself?

Thanks

Ian