'Item: code' and 'Unknowns' in Proclarity

Today my user said she is facing an issue in Proclarity. She is using proclarity which take data from a Cube built on Analysis services. She wants to know what is “Item: code” (e.g.; Item: 0, Item: 1, Item: 2 ….) shown in Proclarity and why it displays different values with “Item” prefix?Now let me explain various aspects of this issue. Why this Item appears?As you know that the cube consists of schemas (star or snow-flake). These schemas are developed with various facts and dimension tables. When we make some selection in the Proclarity, it fetches data (measures) from the fact table and members from the dimension tables. When we produce a grid view in Proclarity, we need to access both dimension as well as corresponding fact rows to that dimension.Eg. If we need to know the Gross Sales Value for sales to a particular customer with customercode (primary key) say 100, we need to fetch one row from dimension and corresponding all the rows from the fact table.This is done with various join architecture where joins on fact and dimensions are based on composite keys.Now if the join is valid (a row is available in the fact row with customerkey 100) but its other attributes (columns other than composite key) dimension table is blank or null for that customer, then Proclarity shows Item in place of the description.
Whereas if there is no corresponding row (value) available in the dimension table for any row in the fact table, Proclarity displays Unknown or you can set it to display Unknown in the report.Now this makes clear why Item or Unknown appears in the Proclarity report. You can say this is because of the dirty data.
Why different numbers after the Item:?The numbers after Item: are the index of the dataset that ProClarity retrieves from the cube. I mean to say this is the sequence in which the member appears in the proclarity report view or you can say the sequence of their appearance in the setup panel. Let me make it clear it with the help of an example:Suppose you have selected some members from the Product hierarchy/members. Now if the Zeroth item has null/blank in the dimension table, the first row will appear with Item:0. Similarly First item shows Item:1 in case of null/blank value in the dimension table and so on.
The figure here shows the Item:5 and Item:6 instead of the customername. This is in correspondence to INDEX 5 and 6 as shown below. Similarly it takes the index number after Item and displays the same.
In the screenshot here you can see that the tooltip displays name in case of
PERFUMERIES but is blank in the other case.
This is the case when the description is blank\null in the dimension table for a valid join.