Query Performance

[Former Member]

Hi ,

Query is taking a very long time to execute.With my ID it gets executed within secs.But through Test USer it takes approximately around 45mins.I tried using RSDDSTAT table,I tried debugging through RSRT , even tried through ST05.But I'm not able to find what can be the problem.According to me it should be some authorization proble..Please let me know how to use ST05 trace .I got the trace & somewhere on fetch it is highlighted.then what next .How can i corretc the error.

Regards,

Anita

[Former Member · Accepted solution]

Hi All,

Details of RSDDSTAT Table.

QTIMEOLAPINIT is 2,593750

QTIMEDB is 16,140625

TIMEAUTHCHECK is 2.057,968750

In St05 it takes a long time to fetch UST10s table.

I dont know how to resolve this issue.

Thanks

Regards,

Anita

[GFV · Accepted solution]

Hi Anita

effectivelly the biggest time is spent during authority check. In ST05 check the SQL Explain for the select statement in table UST01S: may be statistics are not updated? In OSS I saw there are some notes about this table ...

What about Authorization Objects? Are you using Custom ones? Could you be more specific about the checks you are performing with this Query?

Hope it helps

GFV

[Former Member · Accepted solution]

Hi ,

I am using some customised authorization objects.Test user is having authorization to view only some specific

cost center.

For all the cubes stastics is up to date .

Thanks & Regards,

Anita

[GFV · Accepted solution]

Hi Anita,

you say "some customized authorization objects" ... how many?

Are you using author obj based on hierarchies? I saw some notes about (e.g. 838615 Performance optimization with hierarchy). Are they suitable to your problem?

Are you using some variables withcustomer exits?

Hope it helps

GFV

[Former Member · Accepted solution]

Hi GFV,

Thanks for your Quick response.Now I have compressedd all the cubes & I have created the Stastics & Indexes again .

Now its taking hardly 2mins for the Execution.Even the note seems to be helpfull in my case .

Thanks a lot Gianfranco .

Thanks & Regards,

Anita

[former_member184494]

In all likelihood , this might be because of the cache. It might take a lot of time the first time around but then would take a very short time for repeated queries.

Is this problem everytime the query executes for you. I.e if you execute the query using the test user , , it takes 45 minutes for the query and then if you refresh it or open the query again does it take the same time?

And how big is the data which you are reporting on?

Arun

[Former Member]

Anita,

are you sure that from ST05 you cannot have somne useful info ?

Did you check if sometimes some aggregate or buffer are used or not ? If you have some authorization issue I don't think the performance difference would be so high...

Bye,

Roberto

[Former Member]

Hallo Anita

what is telling you the RSSDSTAT Table? Which is the biggest Time? Olap? DB?...

It seems me really Strange that an authirzation isssue make more than 40 minutes.

Can you try to regenerate the query with RSRT?

Is the query complex?

Regards

Mike