View all dimesnion values even if no join

[system]

I have a dimension lets call it DIM1
I put a filter of that dimension: DIM1 “in (1,2,3,4,5…)” which generates a filter:
“DIM 1 in (1,2,3,4,5)” on sql query.

When i put it in my report:

[DIM]
[Metric]

If value 1 (e.g.) of DIM has no value , it does not appear in the report.
Is there any way to put all the values in in clause in my report even if theres is no match in query?

So what i’d like to appear is something like:

1| 2| 3| 4| 5
| 3| | 5

Thanks in advance.

A.S.

---

as2010 (BOB member since 2012-01-30)

[system]

Looks into the below post

Including all available values from a table

I have a cross-tab report where for the row values I have error names, and the columns are each day w/in whatever date range is entered into the prompt. The problem is that the report will only show the error names that have been used within that particular date range, and I need to show the entire list/table of errors (without having to enter a date range covering the existence of the error field), even if its values are zero across the board. Using only Web Intelligence (XI R2) with no back-e…

---

praveenmaddi (BOB member since 2011-05-10)