Modify a dashboard chart containing an obsolete column name

Comments

5 comments

  • Avatar
    Candido Dessanti

    Hi @Gianfranco_Campana,

    My best guess is because of caching, so immerse doesn't know that the column name is changed.

    let's try to reproduce

    I have a simple table like that.

    image|627x478

    then un background, someone renames the column on the underlying table

    
    alter table flights_sk_orig rename column arr_airport_fk to arr_airport_fk_new;
    

    when I return to the dashboard, I will get this error

    image|633x476

    if I try to edit the charts, I cannot change the name of the column because the schema for the table is cached by immerse

    image|337x470

    But leaving the dashboard and returning to the dashboard, remove the caches so the dimension can be changed, because the metadata of the table is going to be re-read so it will reflect the new column name.

    image|559x472

    If someone renames the column while you are working on the dashboard, indeed, you can't directly change the dimension because of the caching, but you can

    1. use a Custom Dimension that will reflect the new name
    2. save and leave and re-enter the dashboard

    Anyway, I will report this to the FE team, asking for this enhancement .

    Candido

    0
    Comment actions Permalink
  • Avatar
    Gianfranco Campana

    Thank you Candido, the problem is not in refreshing the cache to reflect the new name, but in saving the chart once the correction is applied: the "Apply" button on top/right corner of the table chart, is greyed out, not selectable, although the cache is already updated and the correction applied. I'm using Omnisci free 5.7.1

    0
    Comment actions Permalink
  • Avatar
    Candido Dessanti

    Hi Gianfranco,

    I have been able to apply the changes when I used a Custom Dimension (this is the only way to correct the chart without close and re-open the dashboard), and after a save -- leave and re-open of the dashboard.

    Let me check with 5.7.1, because I tried out with a developer build (while the artifact of Immerse would be the same)

    Steps:

    1. Create a new dashboard with a pie chart using a field f1 for the dimension and a count for the measure
    2. Saved the chart
    3. Renamed the f1 field to f1_new
    4. Refreshed the charts and got the error
    5. Entered in edit mode on the charts, changed the dimension to a custom dimension, and entered the new field name f1_new; the chart now works, and the apply button is enabled.

    Did the previous steps from 1-4 exited and re-entered the dashboard Entered in edit mode in the chart, selected the dimension, selected the f1_new field; the apply button is enabled, and the chart works.

    So I guess I am missing the question, or you are doing some steps differently; could you please share your steps?

    Regards, Candido

    0
    Comment actions Permalink
  • Avatar
    Gianfranco Campana

    Here my test:

    1) Create a new dashboard with a table chat 1 Dimension and 1 measure. Saving the dashboard. 2) Rename the table column used in the table chart. 3) Exit and re-enter the dashboard and get the error (Apply button is disabled) 3) Correct the column name in the chart : Now Apply button is enabled.

    Therefore, in this way the behavior of my dashboard is not replied, and the differerence is my dashboard use more measures.

    In fact, repling the above steps with two measures with the changed column name, instead of only one, still leds to the error where the Apply button is disabled (could you just try the same)?

    From my tests, the Apply button is disabled when there are more then one measure (with the cache already updated and all the measures have been corrected). But, if you remove all the measures, and add them again with the right column name, the Apply button is enabled.

    This is a problem when you have a number of custom measures with some complicated formulas ( my case) where is simple to change only the column name, but is time demanding recreating the measure from scratch for each chart using that column name.

    P.S: I solved downloading the dashboard, editing with sed, and reauploading.

    0
    Comment actions Permalink
  • Avatar
    Candido Dessanti

    Well, editing the dashboard solves the problem but it's a little extreme solution.

    anyway, I tried out with a table using 2 and 3 measures, but I cannot reproduce it.

    I tried with a text encoding dictionary and with a binned integer but everything works (both methods)

    image|651x407

    0
    Comment actions Permalink

Please sign in to leave a comment.