discontinued value, first date in month

[Former Member]

Hello,

I have one measure Sales Revenue and I need it to show it in two columns in report. In one column have to be Sales Revenue for week and in other Sales Revenue for week-1

I solved it in webi - i did two queries and one prompt. The one query containes only dimensions week, the second query containes week-1. In prompt I put only one value.

Queries are ok, but the output in report containes one values, which is discontinued and I don't know, what does it mean?

The second question is: How can I show the first day of the month?

Thank you for your answer. Have a nice day,

Marika

[amrsalem1983]

at the "Data" tab, where you can see all the dimensions and measures

go down , you will find an option to show alphaptical or by query

select Disply by query, so you can see the 2 separate queries with 2 separate items.

good luck

Amr

[Former Member]

Yes, I knew it, but this two dimensions return me same values. This is the problem. Not that I can´t find two dimensions.

[amrsalem1983]

are you sure of the dimension week-1??