Best Of

Hi Bettina Clausen

You are absolutely correct! When I load to a text cube, the transformation works. Not sure if this how I envisaged the ETL function to work. I thought the transformation layer would transform the data before loading to the target cube. Instead, from what you say and what I have just experienced,  it loads to cube first and then updates the cube by applying the transformation logic. So it is more an ELT  rather than ETL!

In fact before I got your reply, my workaround was to load the data as is to a text cube and the have a data flow to transform to codes and store in another cube.

Thanks,
Dinesh

Davide Genini - fyi

Hi,
it is not possible to disable the entire menu. What you can do is disable some of the features contained in that menu:

• the select window can be disabled from the user security profile: enable the "Deny selection editor" option
• Show screen list can be disabled using the "Hide screen list" option editing the WinClient capsule property (as you already mentioned)
• the presentation part can be removed disabling the entire presentation feature. See below instructions

Disabling the presentation feature can be done in the HTML5 app config file you can find in the WebApi Server folder (usually installed under C:\Program Files (x86)\Board\Board WebApi Server).

Opening the AppData>Config folders you will find the "appSettings.config" file.

Editing that file you will find the parameter

<span class="token tag"><span class="token tag"><span class="punctuation token"><</span>add</span> <span class="attr-name token">key</span><span class="attr-value token"><span class="punctuation token">=</span><span class="punctuation token">"</span>presentationEnabled<span class="punctuation token">"</span></span> <span class="attr-name token">value</span><span class="attr-value token"><span class="punctuation token">=</span><span class="punctuation token">"</span>true<span class="punctuation token">"</span></span> <span class="punctuation token">/></span></span><span class="line-numbers-rows"><span></span></span>

This parameter should be set to false. (the BoardWebApiEngine service needs to be restarted after this change).

Please let me know if this helped,
Best regards,

Michele

Hi there,

BOARD comes with an automatic feature that compiles the SQL statement for you when configuring datareaders using ODBC drivers.

If you want to load daily data into an InfoCube structured by month, you can map the day field to the BOARD Month entity. BOARD will automatically aggregate the information at monthly level thanks to the native BOARD time hierarchy.

Hope this helps

Regards,

Michele