offset dimension objects

[former_member539471]

Hi All,

I have a dimension in IDT 'Calyear Offset' = 0 returns current year, -1 previous year and so on . How do i use this in webi report to bring sales for current year.

I have below objects Product, calyear , calmonth. sales, calyear offset, calquarter offset , quarter. My report should look like below...

Prod current year sales

abc 1234

[mhmohammed · Accepted solution]

Hi Pali,

You need to have a filter in the query as Calyear Offset = 0, so it always bring data in report for the Current Year.

Thanks,
Mahboob Mohammed