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