Filter Hardcoded in drill through report

[shindhu]

Hi

I have an Impromptu report with some filters defined on it.
But when i see the sql, it has an additional filter applied on it. (ex: T1.Corp_cd='FoodWorld')

The additional filter is not applied any where in the catalog, or table level restrictions or user level restrictions.

To give some more information on this, this report was created for drill through from a cube. First time the drill through report was ok(i.e with no filters) but when i drilled through on Corp_cd='FoodWorld' it has shown me the details of the selected corp_cd in the drill through report. Some how that filter stays there in impromptu report. i.e even i dril through on some other dimension also, the above filter is still there in the query.

Could you please help me out to resolve this

Kishore

 

[DoubleD]

Open the Drill-Through report by itself, remove the filter, and resave it.

I am what I am based on the decisions I have made.

DoubleD