Archived discussions are read-only. Learn more about SAP Q&A

Dynamic Filter in Web Intelligence

Hi!!!

I need help about one issue. Let me explain my problem:

I have a webi report, this report contain the sales by day. The problem is that my variable of day contains values from current month, last month and month of las year. Example:

01.04.2010

01.3.2011

01.04.2011

02.04.2010

02.03.2011

02.04.2011

My variable of day has this behavior because i need to compare the sales of current month vs las month and current month of last year.

The measure that has the sales is database delegated.

In other view of my report, i need to show only the sales of current month, but when in my webi report filter the sales with the condition "is not null" (to hide the information about last year and last month) the intersaction between day and sales show me the following message:

01.04.2011

Sales: #NOT AVAILABLE

I really need to reach this behavior, but i dont know how to do to work my filter.

Someone can help me please?????

Ruddy Alvarado.

I am using BO XI 3.1 SP3

Not what you were looking for? View more on this topic or Ask a question