locked
ProClarity Web Professional Query RRS feed

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hi Community,

     

    I have a query regarding the value for one of the attributes in ProClarity report. (It's regarding ProClarity Web Professional report). 

    In the report, one the numeric attribute's values are not displayed correctly. (for eg, it's shown as Item <no>, whereas it should show it as a number)

    Even on checking the data mart, it's seen that there is no null value present for the above attribute in the table.

    Could anyone please let me know why is the value not displayed in the report?

    Even the cube processing has been successful.

     

    Any pointers would be helpful.

     

    Thanks in advance!

     

    Friday, August 8, 2008 12:44 PM

Answers

  • Question
    Sign in to vote
    0
    Sign in to vote

    Hello.

     

    If you're seeing 'Item0' as a member name it is because there is an empty value from the table where the cube is getting the name from.  What happens if in BIDS you browse the dimension in question - what do you see there for the name of the domain member that is showing up as 'item 0' in ProClarity?

     

    The only way to avoid 'Item 0, Item 1, etc' from showing up in ProClarity would be to ensure all empty cells are removed in the ETL process.

    Tuesday, August 12, 2008 4:02 PM