Report timing

[cognos05]

Hi,

I am running a report build out of a fm package which has a relational table and also a transformer cube in the package.

The report has 3 tabs and runs like in 15 to 20 seconds when i run as admin , but when i run the same report as some other user from a different security group ,the report takes 3 to 4 minutes to run . Other user has access to all items in the report .

Any idea on how to trouble shoot this one . If its an access issue the report will not run right.

Thanks,

[MFGF]

Hi,

I am running a report build out of a fm package which has a relational table and also a transformer cube in the package.

The report has 3 tabs and runs like in 15 to 20 seconds when i run as admin , but when i run the same report as some other user from a different security group ,the report takes 3 to 4 minutes to run . Other user has access to all items in the report .

Any idea on how to trouble shoot this one . If its an access issue the report will not run right.

Thanks,

Hi,

Are there any security filters defined in FM that may be triggered for some groups but not others? It's possible the filters might be firing and returning the same result set but impacting the query sent to the database? Might be worth viewing the generated SQL as you (the Admin) and as someone in one of the affected groups to see if there are any differences?

Cheers!

MF.

[cognos05]

Thanks, I do have a lot of queries on the report ,should i check each one .

[MFGF]

Thanks, I do have a lot of queries on the report ,should i check each one .

Hi,

What does "a lot" mean here? If we're talking 50 queries, for example, would 3 to 4 minutes actually be a reasonable time for these to run?

Cheers!

MF.

[cognos05]

No I meant i had like 5 to 8 queries ,may be a specifc query is having some issue .

I checked there is only one relational query and rest all are MDX.

[MFGF]

No I meant i had like 5 to 8 queries ,may be a specifc query is having some issue .

I checked there is only one relational query and rest all are MDX.

Something else to check is whether the report is using relational-type techniques on the data in the cube (for example detail filters)

Cheers!

MF.

[cognos05]

I seperate the reports in to relational page and page created using olap.
The relational comes back faster results, the olap uses custom views in transformer which is causing the slowness .
I am looking in to this yet.