Skip to Content
0
Former Member
Jan 12, 2012 at 06:39 AM

Question regarding BI Statistics (New) Content

158 Views

Hi,

I have a requirement to bring the following fields from the statistics cube (0TCT_C01, 0TCT_C02 and 0TCT_C03).

Technical Name of the query

Query Description

Date Created

USERID Who Created It

Date Last Changed

USERID Who Last Changed It

Date Query was Last Executed

USERID Who Last Executed it

But, looks like none of the above cubes, have all the fields together. So, I managed to bring the data from this table V_COMPDIR_COMPIC (I know this view is based on old statistic flow, but still it gives the information what I except), but USERID Who Last Executed was not available in the view. I found the information (userid who last executed) available in RSDDSTATINFO and manage to bring somehow by joining the view and tables and it gives partial information, but missing lot of records too.

1) Can you please let me know whether is there any table or views or cubes which satisfies the above requirement?

2) Any idea, how many days of statistical data get stored in our BI system, right now admin parameters set to keep the statistics data for 75 days, will it affect the system performance, will it be acceptable to increase it to 100 or 150?

Any help is much appreciated.

Thanks in Advance.

Sathish