cancel
Showing results for 
Search instead for 
Did you mean: 

Displaying No. of Days in the report???

Former Member
0 Kudos

Hi All,

I have to display the number of the day the report is executed on. I thought that I can do it using the Text Variable and Offsets in it to display the day from the input date. But the problem is, the customer wants to display the number of working days so far and not the day of the input date i.e if we run the report today i.e 09.11.2006 the the number of the day would be 7(taking off saturday and sunday).

Has anyone got any solution to this?

Best Rgds,

James.

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member
0 Kudos

Hi,

you can use the factory calendar to calculate only working days. That wil let you count only the working days and not Saturday, Sunday or holidays.

Kin dregards

/martin

Former Member
0 Kudos

Hi Martin,

Can you please let me know how to use the factory calendar in the Query?

Best Rgdsm

James.

Former Member
0 Kudos

Hi,

Try to check queries on BW Statistics cubes. There is a query which shows number of times a query has been run or executed?

Thanks