Drill Mode

[ShyamRewaskar]

Hi friends.

I have one drill report and th last dimension in the hierarchy is <user>.
Now I want this drill report in such a way that, any user when retrieve and refresh the document from the repository, he will see his own data in the drill report, there after he should allowed to drill up.

I cud able to do it in static report but for drill down I could not see any option for it. Is there any way to do this through SDK.

Any solution to this will be a great help to me.

Thanks
Shyam

 

[rpyneuk]

I have a couple of reports with drill filters in them and these seem to be seem to be refreshed on the repository at the hierarchy level at which I saved them. So in this case it might work doing that and saving at user level, from which they could then still drill back up.

Russ.

 

[ShyamRewaskar]

Thanx for ur suggestions

But my need is little different.
In my hierarchy.. user is at the bottom.. and this is also a bouser.

Now when this bouser retrieve a report from the repository and refresh it... he/she should see his data on the report.
Means table will have user1 & sales qty..
if user2 login and refresh the report he will see
table having data for user2 ie table will ve user2 & qty like this...then he shoul allwed to drill up
This we will have to do on run time...
You can pass the BOUSER as a filter but it is for static report... how can we do it in drill report.

If there is a way to do it..pleasse let me know

Thanx
Shyam