Week data of month

[Former Member]

Dear Experts,

We created the universe in IDT based on HANA calculation view, need to show current week data and next 3 weeks data(coming weeks) of month in Dashboard

Requirements is like below.

Current week + Amount

Current week + 2nd week

Current week + 3rd week

Current week +4th week.

Current month of current year and rest of month of current year.

Is it possible to define the above requirements in IDT data foundation or we need do it in HANA calculation itself.

Can any one help me on this requirement.

Many thanks in advance!!

[Former Member]

Hi Ravi,

If it is kind of standard requirement and useful for the other reports, then i would suggest to create at database level (HANA).

We can create multiple columns at date dimension level with the help of below codes

Current_Week => case when year(date) = year(current_date) and week(date) = week(current_date) then 'Y' else 'N' end;

Next week => case when year(date) = year(current_date) and week(date) = week(current_date)+1 then 'Y' else 'N' end;

Once we have these flags set in different columns, create restricted measures at calculation view level.

Regards,

Venkat N.