cancel
Showing results for 
Search instead for 
Did you mean: 

ODS reports performance

Former Member
0 Kudos

Dear All,

we had a report created on the top of the ODS with selection criterion as profit center,now when we click the profit center varible entry to see the selection a window pop up and it is there for 30 mins after that only we can make any selection ,request you to tell me the solution to improve the performance of the variable input.

thanks sapta

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

hello,

the oprofit_ctr is already set to read data from Master data for filter value selection.and about navigational attribute we are using only four navigational attribute.pls help

thanks

former_member192142
Contributor
0 Kudos

Hi,

Have you created any indexes in the DSO definition. If not, try and create an index on profit center.

-J

Answers (4)

Answers (4)

Former Member
0 Kudos

i everything fails, go to rsrt enter your query, properties and turn on cache that will help a little

Former Member
0 Kudos

Jyoti,

If ODS contains more data, then change infoobject settings to read data from Master data for filter value selection.

RSD1 --> infoobject(eg: 0costcenter) --> change --> Business Explorer tab --> Query Def. Filter Value Selection.

Try to minimize usage of Navigational attributes, if possible include selection variables directly into target instead of using as a navigational attributes.

Hope it Helps

Srini

Former Member
0 Kudos

hello,

the sid generation check box is ticked.

former_member192142
Contributor
0 Kudos

Hi,

Have you activated the flag "SID Generation" in your DSO? If not, try that (if you are on 7.0).

Best regards,

Jacob