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