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

What is the logic to get displayed a chart weekly?

Started by inu, 22 Aug 2016 08:12:23 AM

Previous topic - Next topic

inu

Hi Team,

I created a chart on daily basis(if user selects date , data shown accordingly, if user doesnot select any date ,  current month data will display), i wrote the logic  as follows

if (?Par_ViewType? = 0) then
([Fact Application].[Time Dimension(Login Date)].[Date Alternate Key]
between _first_of_month (_add_days (current_date,-1))  and _add_days (current_date,-1))
else
([Fact Application].[Time Dimension(Login Date)].[Date Alternate Key]
between _first_of_month (_add_days (?Par_Date?,-1))  and _add_days (?Par_Date?,-1))


Now requirement has changed , chart should display data weekly (if user selects a month , if users dont select any month , chart should display all month of current month)

Note: week key and week name query items are available in the namespace.

Can you please guys , tell the logic , so that i can finish it .
I really learnt many things from this forum...Thanks


Regards
Inam

T