Topic
  • 3 replies
  • Latest Post - ‏2012-12-21T08:24:05Z by SystemAdmin
SystemAdmin
SystemAdmin
15496 Posts

Pinned topic My Crosstab returning a Null Row for outer join

‏2012-12-18T12:05:36Z |
Dear Experts ,
I have a requirement of showing all date columns ( even if we dont have data for them ) and dimension's different values in individual tabs of Excel sheet . To implement this i have outer join with calnder query with my main corsstab query . This crosstab query has the dimension values .
Since we dont have data for some dates , its creating a Null tab while downloading it to excel ( this NULL is the outer join output for the dimanion ) .

When i place it in a crosstab the display is coming like

Date 1 Date 2 Date 3 Date 4
Dim 1 1 2 4
Dim 2 2 5
Null

Please help me finding any solution to suppress this NULL value from the final query .

Note : We need to show only those dimension which has data but all dates although no data for them

Regards
ImsMad
Updated on 2012-12-21T08:24:05Z at 2012-12-21T08:24:05Z by SystemAdmin
  • JVJ
    JVJ
    10 Posts

    Re: My Crosstab returning a Null Row for outer join

    ‏2012-12-18T13:28:50Z  
    Option1: Try pulling another column from other table and see if you get any data.
    Option2: Try the replace function and populate the column with 0 or space and see if shows up.
    Option3: In the cube properties the nulls might be suppressed, please check the properties once.
  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: My Crosstab returning a Null Row for outer join

    ‏2012-12-21T08:20:53Z  
    Hi All ,

    This steps are not working for me . The situation is A is the dimension and others are date column . Now we are
    01/01 - A
    02/01 - A
    03/01 - A
    04/01 - A
    05/01 - A
    06/01 - A
    07/01 - A
    08/01 - A
    09/01 - A
    10/01 - A
    11/01 - A
    12/01 -
  • SystemAdmin
    SystemAdmin
    15496 Posts

    Re: My Crosstab returning a Null Row for outer join

    ‏2012-12-21T08:24:05Z  
    Hi All ,

    This steps are not working for me . The situation is A is the dimension and others are date column . Now we are
    showing all dimension values with a tab in excel sheet . and due to this situation i am getting a NULL tab in excel output . I tried with Dimension is not NULL at final query but that is removing the 12/01 months .
    But we need to show all months , although no data .
    01/01 - A 10
    02/01 - A 11
    03/01 - A 12
    04/01 - A 14
    05/01 - A 15
    06/01 - A 01
    07/01 - A 123
    08/01 - A 1
    09/01 - A 2
    10/01 - A 3
    11/01 - A 4
    12/01 -