Custom Code Library Extractor - FM AGS_CC_CCLM_EXTRACT

[IanStubbings]

Hi Experts

Just debugging this extractor FM and noticed that all the usage values were 0.  Looking at the code, it dawned on me that the  lv_last_usg_day,  lv_last_usg_week,  lv_last_usg_month,  lv_last_usg_year are not set which is probably why.

Is there an OSS note for this as I cannot currently find one.

Thanks

Ian

[IanStubbings]

Hi Experts

Just debugging this extractor FM and noticed that all the usage values were 0.  Looking at the code, it dawned on me that the  lv_last_usg_day,  lv_last_usg_week,  lv_last_usg_month,  lv_last_usg_year are not set which is probably why.

Is there an OSS note for this as I cannot currently find one.

Thanks

Ian

[RiabovAleksandr]

Hi Ian,

as we have marked only 'Last Usage' during Guided Procedure, it fetches only Last usage

the rest are for information from Early Watch Alerts

[IanStubbings]

Hi Alexander

I don't quite understand your reply. 

There is data in the table that is being looped around but the values circled are never populated in the FM and therefore this loop doesn't achieve anything.

Do you mean that this code is obsolete?  Should I not expect usage data in the 0SM_CCLM cube?

Thanks

Ian

[RiabovAleksandr]

Hello Ian,

from SP11 we have new architecture of CCLM.

Usage is stored in 0SM_UPL*

Objects in 0SM_CCLG

Some attributes in 0SM_CCLM, etc

Now I see your question properly.

These 3 lines are obsolete, yes.

     wa_extractor_data-field44 = lv_last_usg_week.
     wa_extractor_data-field45 = lv_last_usg_month.
     wa_extractor_data-field46 = lv_last_usg_year.

thank you for spotting this!

[IanStubbings]

Hi Alexander

Yes, I realise the architecture has changed. I am configuring SP12 after previously starting with SP07.  I thought 0SM_CCLM was a new cube though?

So I should ignore usage info in 0SM_CCLM.  Should I also ignore quality as well?  Is this cube just used for attributes such as change dates and lines of code etc?

I'm taking a look at the queries and not seeing much data whichever cube I look at.

Can you suggest some queries I should focus on perhaps?

Thanks

Ian

[RiabovAleksandr]

Hi Ian,

go to rsrt on solman and look into 0SM_* queries

you will find many useful queries

[IanStubbings]

Hi Alexander

Yes, there are many indeed but which ones would you recommend? i.e.Top 5 queries that customers use?

I ask as I'm not having much luck finding data with those that I have tried so far (0SM_CCLM based) and the UPL ones have so far timed out.

Thanks

Ian

[RiabovAleksandr]

Hi Ian,

well, it depends on what you have to find.

There are neither popular nor unpopular.

You can always go to rsa1 -> pick cube -> right-click -> display data.

Choose attributes you want and display.

as well you can use Ad-Hoc reporting, but don't forget that it is based on tables, not cubes.