If you are unable to create a new account, please email support@bspsoftware.com

 

News:

MetaManager - Administrative Tools for IBM Cognos
Pricing starting at $2,100
Download Now    Learn More

Main Menu

how to display date even when value is not available in database

Started by inu, 24 Aug 2016 06:07:40 AM

Previous topic - Next topic

inu

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

MFGF

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.
Meep!

inu

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

MFGF

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.
Meep!