COGNOiSe.com - The IBM Cognos Community

IBM Cognos 10 Platform => Cognos 10 BI => Report Studio => Topic started by: inu on 24 Aug 2016 06:07:40 AM

Title: how to display date even when value is not available in database
Post by: inu on 24 Aug 2016 06:07:40 AM
Hi

Can you please tell me , what function and logic should i use to display the date..

My requirement is
I am using running_count(current Date)...First date is not displaying becuase value is there


Thanks
;Inam
Title: Re: how to display date even when value is not available in database
Post by: MFGF on 25 Aug 2016 03:56:35 AM
Quote from: inu on 24 Aug 2016 06:07:40 AM
Hi

Can you please tell me , what function and logic should i use to display the date..

My requirement is
I am using running_count(current Date)...First date is not displaying becuase value is there


Thanks
;Inam

Hi,

You can't display something that isn't there. It has to be there for you to display it. Typically you'd have a time dimension with every date in it and use this.

MF.
Title: Re: how to display date even when value is not available in database
Post by: inu on 25 Aug 2016 05:56:19 AM
Quote from: MFGF on 25 Aug 2016 03:56:35 AM
Hi,

You can't display something that isn't there. It has to be there for you to display it. Typically you'd have a time dimension with every date in it and use this.

MF.

Other date also not working.
Actually i am using running-count(date)...suppose Aug 1, 2016 is not available, then Aug 2, 2016 will come in the first row...

that is the issue...

actually my requirement is as attached
1-9(Week 1)
10-16(Week 2)
17-23(Week 3)
24-end of month(Week 4)


Can you please help me out.


Regards
Inam
Title: Re: how to display date even when value is not available in database
Post by: MFGF on 25 Aug 2016 08:59:17 AM
Quote from: inu on 25 Aug 2016 05:56:19 AM
Other date also not working.
Actually i am using running-count(date)...suppose Aug 1, 2016 is not available, then Aug 2, 2016 will come in the first row...

that is the issue...

actually my requirement is as attached
1-9(Week 1)
10-16(Week 2)
17-23(Week 3)
24-end of month(Week 4)


Can you please help me out.


Regards
Inam

Why are you posting the same question in multiple threads?

http://www.cognoise.com/index.php/topic,31375.0.html

I honestly can't understand what you're trying to do here and how it makes any sense?

MF.