design a desktop Intelligence report which runs on daily basis.

[Former Member]

I have to design a desktop Intelligence report which runs on daily basis.

example:- Report that run today fetches previous day data in deski report.

Can you please help me with that what prompt or fiters i have to apply and how to design this?

[denis_konovalov]

I have fixed your tags.
Your primary tag was completely irrelevant to the question you have or product you're using.
The Desktop intelligence is a dead product that is not supported by SAP anymore, so there is not tag for it and Webi is the closest to it.

[amitrathi239]

check below link to understand how to create yesterday date object in the universe and how to use.

http://www.dagira.com/2007/08/22/dynamic-dates-part-i-yesterday-and-today/

[daniele_tiles2]

Hi Vasha,

as Denis pointed out, Desktop Intelligence is a dead product, so the first important suggestion is to move to WebI.

Second: this kind of reports really depends on your source (DB and Universe). Because you've to define which date in your datasource you should compare with the previous day date, and then you can implement a filter, with the correct DB syntax.

HTH

Daniele

[Former Member]

Hi Daniele,

Thanks for your quick answer.
You are absolutely right! this product is out of support, but in my company so many report runs on this product itself. Hence , m asked to develop one report on it.
well, my requirement is have to design a report which runs daily and get the previous day report. In my DB , there are scheduled jobs which runs daily from there we get data into our report.
so my question is how to implement a filter in the report which takes previous day data into my report.
Thanks

Varsha