Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I want to delete or avoid the unwanted bars in below graph highlighted Black.
Regards,
Karthik
Hi,
Go to dimension tab->select Supress null.
Regards
Hi!
Go to dimension tab and Select Dimension and tick Suppress When Value Is Null Check box.
Hi,
Thank you very much for the quick response. I have got it.
Hava a good day.
Regards,
Karthik
Hi ,
I need to remove the synthetic key in the table.
Can you suggest the requested script to remove the synthetic key.
Regards,
Karthik
Hi,
Create key
like
field1&'-'&field2 as key
and rename both fields in table
Regards
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
Hi,
Please find attached files and please let us know how to delete the synthetic keys.
Regards,
Karthik
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