on 11-09-2006 10:03 AM
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.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
80 | |
24 | |
11 | |
9 | |
7 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.