Best Of

Re: Can I deactivate column algorithms calculating "live"?

Hi there Jack,

You should be able to achieve this by having another set of blocks (that are hidden) in your layout, which are the same cubes that have data-entry enabled on them (in the existing blocks). Then change the algorithm so that it's calculating on the "hidden" blocks, rather than the blocks where the user is doing data-entry. I believe the values in the "hidden" blocks should not change until AFTER data-entry has been saved - so therefore the algorithm result would stay static until after date-entry is saved.

Do a test and let me know if that achieves your desired result.

Cheers,

Craig Parris

Unknown

1

Re: Export to Excel error

This occurs when there are specific border colours applied - so you need to update the Entity Formatting and remove borders. (Our company does have tickets raised with Board about this - one suggested workaround is that the data-view should be able to be successfully exported from Web, rather than the Windows client ... although I'm yet to confirm this myself). Hopefully the fix will not be too far away, as we now have several clients getting frustrated by this issue

Unknown

2

Re: data reader file name substitution variable

Thanks everyone for the great suggestions and options. I will let you know how I go. This is a cloud environment (Azure) so could make some of the scripting suggestions interesting but conceptually great.

Dinesh Chand

1

Re: On a BOARD cloud environment is there a variable available to identify whether the instance is the S

Thanks Bob. I did see this but wanted to see how this would work on Cloud environment. These variables are set up by the Cloud support team when the environment is provisioned. Also if you are using BFC the CONSO folder is mapped to Z drive (Azure storage) as well.

Dinesh Chand

1

Re: data reader file name substitution variable

Thanks Brendan Broughton. This is the method I adopted for this cloud client.

Dinesh Chand

2

Re: Data Reader ETL issue with Text file

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

Dinesh Chand

4

Re: On a BOARD cloud environment is there a variable available to identify whether the instance is the S

Thanks Antonio - this worked perfectly!

Cheers,

Dinesh

CC:

Nigel Ephraums

Dinesh Chand

4

Re: ODBC & Bord mismatch

Hello Federico Cazzalini,

Thanks for your precise answer, I firstly tried the Data Fast Track. The work is done !

Later I'll update to Office 64 bit.

Have a good day, and thanks again,

JR

Julien RÉBÉCA

1

Re: Disable Web Client Menu Options

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

Unknown

1