Best Of

Hi,

Sparsity implies that there are at least two dimensions in a cube. This error usually occurs when trying to structure an InfoCube Version as 'sparse' when it has only one dimension. For InfoCubes that have only one dimension we should define the single dimension as 'dense'.

Have a look at this section of the Help Introducing sparse structures 

Regards,

Antonio Speca

Hi there,

small differences in the Checksum % are likely due to rounding.

The Checksum function performs a grand total of the version, then the percentages are calculated based on these totals (which are displayed in the colum to the left). The grand totals are rounded to the seventh digit (7 spaces from the left), hence the small differences in the percentages.

Small rounding differences present no database or reporting problems.

A possible solution could be to re-define the Infocube data type to double. 

Large differences in the Checksum % are likely due to:

-  "orphaned" entity members in the relationship structure (To verify, use the Scan feature in the Relationships screen  - read more about Troubleshoot: effect of missing relationships or How to repair and prevent missing relationships in hierarchies)

- manual deletion of some items of any dimension of the infocube.

A solution for this would be to fix the releationships and proceed with a version alignement

Regards,

Antonio Speca

Hello,

it is possible to disable this feature from the Security Tab. You will need to access with an Administrator profile, edit the Security and define/create a User Security Profile with the "Deny layout designer" option checked. This will apply to all users which inherit this User Security Profile and will apply any device and interface used by these user.

(so if they use the Win Client or HTML5 interface they won't be able to edit layouts in either of them)

Hope this helped.

Regards,

Antonio

Hi,

in order to apply a security, you will have to apply database security profiles to the User profile associated to every user (or group of users).

You can find how to and more info in our online manual Database security concepts 

You can filter and/or apply restrictions on visibility of elements of dimensions (so, in your case, different Companies or Reporting Units), and combine this with the visibility of different information (so you can allow for visibility for revenues and maybe hide the margin from a specific set of users).

Available for further help

Ciao,

Antonio Speca

Yes,

you can check the Board 10 online

Board 10 Web Server Installation and Configuration

The settings can usually be found in the following path "C:\Program Files (x86)\Board\Board WebApi Server\App_Data\config\appsettings.config"

Here you have the following parameters:

• Host: here you can define the host and port, the default value is set to “http://*:80/”, to change the port to another one (let’s say 90) you might change the value this way “http://*:90/”
• BoardEngine: Address of the server where the Board Server service is running. If the Board Web Server is installed on the same computer of the Board Server, specify localhost (default value)
• Port: here you define the Board Engine port, default value is 9700
• LoacalAuthEnabled: if true, it allows username and password authentication
• WinAuthEnabled: if true allows windows authentication
• anonymousAuthEnabled When enabled, all users connect without having to type username and password, all users will inherit the same credentials.
• anonymousAuthUsername: username for anonymous authentication
• anonymousAuthPassword: password for anonymous authentication
• useSSL: Enable this option if your Board Server service requires SSL authentication.
• headerTitleHidden: this setting is used to show/hide the screen name in the top bar of the web client value, it can be set to true or false
• PresentationEnabled: this setting is used to show/hide the presentation environment, it can be set to true or false
• chatEnabled: this setting is used to show/hide the chat environment, it can be set to true or false
• cognitiveSearchEnabled: this setting is used to show/hide the cognitive space environment, it can be set to true or false

Regards,

Antonio