I want to avoid exta bar graphs?How to do it?please give me the suggestions

[#1]

Hi All,

I want to delete or avoid the unwanted bars in below graph highlighted Black.

Regards,

Karthik

[PrashantSangle]

Hi,

Go to dimension tab->select Supress null.

Regards

[pokassov]

Hi!

[#4]

Go to dimension tab and Select Dimension and tick Suppress When Value Is Null Check box.

[#5]

Hi,

Thank you very much for the quick response. I have got it.

Hava a good day.

Regards,

Karthik

[#6]

Hi ,

I need to remove the synthetic key in the table.

Can you suggest the requested script to remove the synthetic key.

Regards,

Karthik

[PrashantSangle]

Hi,

Create key

like

field1&'-'&field2 as key

and rename both fields in table

Regards

[Anonymous]

Another way to remove the synthetic key would be rename the field ( aliasing ) or use qualify all and unqualify statement before the table name and keep only the field which has to join ( unqualified ).

Best Regards,

Shubham

[#9]

Hi,

Please find attached files and please let us know how to delete the synthetic keys.

Regards,

Karthik

[PrashantSangle]

Hi,

Just Rename 3 Field from Fact Deposits and Fact Loan Table

Age,

Principle Amount,

Expenses

and

Keep Account Id so that it will create association between above two tables

Regards