Report designer - Check Data Provider button missing

[Former Member]

Hi,

We are in Bi 7.0 Sp 17. I found out that reports designer with hierarchies don't offer the 'check data provider' button- In field catalog, over the query, right button. If report has a fixed structure button appears...

I need it to refresh the dataprovider with new filter values set in the query

Have you noticed this? Do you think it's a bug in report designer or can it be my sapgui version?

Regards,

Ruben

[Former Member]

Hi Ruben,

I think I am correct in the following, it is my understanding that the Check Data Provider button only works on fixed (Static) structures not dynamic characteristics. Therefore if you add in additional characteristics (dynamic) after you have inserted the dataprovider into the report designer then you will not be able to use the Check Data Provider button.

Please see the following link for explanation.

http://help.sap.com/saphelp_nw04s/helpdata/en/43/8a95791b1f22a8e10000000a1553f6/content.htm

If you find additional help on this please share, as RD has caused lots of "challenges" and is still in development as far as I am concerned. Be glad when its superceded.

Regards

Nick

[Former Member]

Hi Nick,

I think that you are unfortunately right.. I didn't knonw the link you posted but it seems like it's true.

We have a workaround to refresh the new filters that we set into the query: Go and insert a new infoprovider and choose the same query that you already had into the report... Then you can select the new filters.

It is not a clean solution, but at least it works...

Thanks and regards,

Ruben

[Former Member]

Hi Ruben,

Thanks for the points, we have had some history with the report designer and whilst it has its issues it can still produce some decent stuff if you persevere.

I think the trick is to make sure you have all of the relevant characteristics you need inserted in the first place.

As a side note, RD does (or should) recognise any filter changes you make with characteristics already inserted.

Hope this helps you to not insert a new dataprovider every time you make a change to the query.

Regards

N