Displaying all values of a dimension even if no value

[system]

Hi,

How do I display all values of a column,even if there is no sale for it?
Please help

-ajq

---

anushajq (BOB member since 2005-02-22)

[system]

Create two data providers.

One for the dimension to display

the other with the dimension and revenue measure…

Link the two DP’s on Dimension.

---

BO_Chief (BOB member since 2004-06-06)

[system]

Hi anushajq,

This has been discussed in this board many number of times. Try searching for “Null values”. Here is one of the link that might help you.

Need Help on Null Values.....

hi everyone, I have a report where i display the "Count" of submissions done everyday. So what i have done is, i have created a group with options "for each day". (ie) Sample Data, [i:97509e68f0][b:97509e68f0]Date---------Submission[/b:97509e68f0][/i:97509e68f0] 1-Mar-05--------------4 1-Mar-05--------------5 1-Mar-05--------------2 2-Mar-05--------------1 2-Mar-05--------------4 2-Mar-05--------------15 3-Mar-05--------------1 3-Mar-05--------------21 3-Mar-05--------------2 4-Mar-05------…

In short as irfanahmed786 said create a data provider for “field” which has all the values and link this.

---

Raja Saripalli (BOB member since 2005-12-14)

[system]

i AM Sorry, i did not explain the details. I did what everyone has said but it does not work. The reason I think is that the user wants to see all values for each break level, not just the values of that break.

Take the Island resort marketing universe as an example:

The report has a break on country, and also displays resort and revenue.

This is what the user wants to see :

Country Resort Revenue
France FrenchReviera 100
BahamasBeach 100
Hawai 100

Country Resort Revenue

USA FrenchReviera 100
BahamasBeach 100
Hawai 100
It doesn’t make sense but that is what he wants. How do I do it using context? This contextual formula, ForAll does not work.

-ajq

---

anushajq (BOB member since 2005-02-22)