I created a cube that have only one dimension Employee name and measure has a
colmn name Amount.
My amount measure is keep ccoming blank even there are some employee who
have data beside the null values.
Also the Total for all Employees also coming Blank.

What I need to do to fix it.
Please help


Thanks
Tanweer

how many rows are really processed?
what's appends when you hide empty cells? does the grid is empty (no cells
displayed)?

have you setup any format for your measure?
does it a measure or calculated one?


"Tanweer" <Tanweer (AT) discussions (DOT) microsoft.com> wrote

In the fact tabel I have about 8000 rows, there is no index on the fact table
( I created manually every tiem I need to rebuild the cube)

There is only four measures using Aggreate function Sum and one measures
using Aggregate function count

Only one Dimension to show employee name the dimension is created using a

key to connect to another table to show the data from

Cells are displaying however no data.
Some rows in my database has Null

No format was setup

NO calculated one.

Thanks
Tanweer
"Jéjé" wrote:

the fact table contain 8000 rows, but does the result of the process is also
8000rows?
remember that AS create some joins when it load data from the database,
these joins can result in an empty result!!!
At the end of the process, AS display the real number of rows processed,
which could be different from the rows in the database.

When you are in the edit page of your cube and switch to "data" view, then
click to filter empty cells from the grid, does the grid continue to display
something?
If yes, whats appends when you double click on a cell? (normally, you'll see
a popup window with some cell information, like value and display (or
formatted) value)


"Tanweer" <Tanweer (AT) discussions (DOT) microsoft.com> wrote