Show Column with empty measure value not working

[Former Member]

Hi Experts

I am on BI4.1 SP5 Patch 9 and i am trying to create new report in webi as shown->

I wanted to show company3 in my report and keep my column static but company3 is not showing and i tried using Table properties and also check note -1491004  but no success..

[amitrathi239 · Accepted solution]

Hi,

try with right click on the table->format table->checked the check-box "avoid duplicate row aggregation"

Amit

[Former Member · Accepted solution]

Hi Amit

It did not worked, It just broken GL1 and GL2 values with each company in separate lines

Thank you..

[amitrathi239 · Accepted solution]

other option is add one more webi query in the report and drag company code object only.merge both objects at report level and use merged object in the crosstab

[Former Member · Accepted solution]

Thanks that worked perfect!!

[Former Member · Accepted solution]

I got one problem, I have to create multiple blocks as below with different GL hier ( GL3 , GL4)

The above soulution worked for one block but when i try doing for block 2 then i see that field Company code with bold value can not be merged

[amitrathi239 · Accepted solution]

Drag these fields in the seprate table.after that refresh the report once.after that you will be able to merge.this is happening beacuse query stripping is enabled in the report and these objects are not in use.

[Former Member · Accepted solution]

Wow awesome! thanks!