-
Impossible to reset selections after apply dynamic selection using a procedure
Hi to all, I have a problem regarding a procedure. In a screen I have created a label linked to a procedure that apply a dynamic selection on an entity. The selection run perfectly (to check this I have a label that shown the current selections). Unfortunately when I run the procedure clicking on the label, I cannot reset…
-
Top 15 rank v's remaining entities
I need to create a report that shows the top 15 entities with total and share. This is easy and I can do. The part I am having trouble with is how to display the remaining entities that are not top 15 and what share they make up. I don't need to see the detail of the remaining entities, rather just want to see them as a…
-
Add a profile photo
Hi Boarders How do I update my Board profile with my photo? * When I go to the Update profile page and click 'Image' I am given a space that I can enter text into and the circular profile image changes. * There is no ability to browse to an image * If I update the text space with a path to an image there is no change to…
-
Paste in Place?
DESIGN QUESTION: I may be asking a VERY basic question here, but it appears the rules for pasting Objects (inc. layouts, buttons, selectors) from one Screen to another are rather... haphazard. Are there any techniques for selecting an object or group of objects, copying them, and then pasting them to a new screen and…
-
BOARD 11 SQL titles not displayed in procedure step details
QUERY Has anyone been able to display the SQL data reader details in DB Procedures? DETAILS In re-writing a dataload procedure, I noticed that SQL data reader details are not shown and require the user to open the step but text file data readers (ascii) do display the title of the reader. Image 1 below shows Steps 11 to 14…
-
Navision 2009 Table Structure
I am working with a client who is using an MS SQL Server table structure in the Navision 2009 format. They wanted to know if there is someone who has extracted from this type of system and if they could reach out with some general questions.
-
DB Security - dynamic selection on Cube and Capsule
Hello, is it possible to define a security profile that is based on a dynamic selection on cube and capsule level? I would like users to see only certain projects in different capsules. Therefore I created a cube with three dimensions: User, Project, Capsule. The Capsule entity is the same name as the capsules in my…
-
Passing Headers to API
Hi, We have an API where the authorisation is handled through the use of headers. Is there a way to pass the values using the REST API settings in BOARD and be able to access this API? More specifically: User/password added as part of the headers, specifically the following header: Authorization: Basic XXXXXXXXXXXX Where…
-
What are the available User role and premission that can be assigned within Board Cloud
What are the available User role and permission that can be assigned within Board Cloud
-
Board 11 colour table
Hi I migrated a Database with the capsule from Board 10.5 to 11. I am trying to change the format and the colours of some tables in a specific screen and I have only found the option to change the block colour but the title cell hasn't changed... On the other hand, tables edited in Board 10.5 maintained the colours and…
-
Problem of selection on Time range
Hello dear community, I have a problem that you may have already encountered. Indeed, I seek to make a double selection on the time axis in a procedure to perform a calculation. To be done I created in the time range "Month reporting", which contains only the months of January to December (if we select month reporting =…
-
Board 11 hardware requirments
Hello, we moved to Baord 11 from Baord 10.1.2 but system is now very slow. It was already slow using client but before was good with web interface. Now is very slow. We suppose power of processor is not enough. We have an Intel processor XSS70. Is there available any hardware system requirment document for Board 11? Best…
-
Relationships in BOARD 11
Hi! Is anyone else having problems with relationships in BOARD 11? We have started a total new project in BOARD 11 and we are not being able to determine relationships. Trying to do it manually, members of the entities are not displayed in order to set the relation: Here you can see we have members in these entities: And…
-
I'm trying to select a whole range in a nexel function
The problem I am having is that in the Nexel I am using Range.Whole function in order to see the whole range. However because I have Sub Totals in my dataview ie. different Categories for SKUs it only takes the Range of that category as opposed to the whole column in the dataview. Any help would be great!
-
Undo a Master-Layout selection
Hi all, I have a question about master-layout. I have a screen with a defined screen selection, inside the screen there is a Master-layout that works right. The question is: how can I undo the Master-layout selection? Yes, this is possible by a screen refresh (F5) and I can get the same behavior by a button (procedure), I…
-
Board 11 Upgrade Path
Hi, It's fantastic that Board 11 is now available. Is there a documented upgrade path to upgrade from 10.x up to 11? Any notes to be aware of etc? I'm keen to test what I have built already, but want to follow the correct process first! Thanks
-
gauge chart
Hello, Is there a way to display a gauge chart in Board ? Like this one ? Or anything that would approach something like this? Where for example the 100 : budgeted costs and the arrow would be the actual costs ? So in fact a percentage but where the 100 is displayed like a half pie ? thanks
-
Create counter in a dataflow
Hello I am currently trying to do the following: trying to rank some elements in a dataflow This is the result I would like to obtain (see attachment). Trying to get this result is fairly simple in a view since the ranking function is available. However, it is not available in processes, so I was wondering if someone on…
-
Virtual Cubes in Board 11
Hi All, After installing the latest Board 11 version; I tested the new feature of Virtual cubes. However, even if I use a very basic dataflow, it does not seem to work as expected. 1. I create a virtual cube by Country 2. I perform a dataflow which puts 2 in this virtual cube on every member. (I tested this step with a…
-
BOARD 11 - Calculation Procedure
Hi, I'm testing out the new BOARD 11 and am wondering if some clarity can be given around the calculation procedures and the options within them? I have started a new database which only contains: Time period - 2019 Entity: Item - consisting of 3 members Cube: Sales (Item, Month) Sales Quantity (Item, Month) Now I am…
-
Data flow no more working
Hi community I have a data flow using join that regularly works with version 10.1.2 and is not working with 10.3.0 (last release) See the picture
-
REST API and Structuring Data
I am currently trying to use the REST API connector within BOARD to bring in data. I have been able to successfully make a connection but it brings the data in as rows rather than as columns as would be desired to be able to load to entities/cubes within BOARD. Ideally in the above, "LEADID", "Last Name", "Email" and…
-
Board 11: functions not working in algorithms
Hi everyone, I'm playng with Board 11 and I noticed that algorithms using functions doesn't work. I have tried "if", "concatenate" and "round" functions, but the columns keep empty or 0. :-( Is there anyone having the same issues? Bye
-
DYNAMIC QUARTER
Hi there, Hope someone can help. I am developing a number of financial reports which require a quarterly summary. I am building the report in the same view. I'm finding that I need to use a 'Refer To' statement on Quarter so that I can summarise data for Q1/19 for example. Herein, lies the issue. Next year the report will…
-
Can we create Relationship between two Entities coming from Different Data source, yet sharing the S
Hello All, I have got an interesting situation in Board currently, i am using Board 10.3. Generally Entity Codes are used as mapping points while creating relationship between different entities, right ?! Now my situation is as follows: I have an Entity being populated from Data Source: SQL Database, consider like this:…
-
REST API connection with api keys
Hi all, I need to extract data from a data source using the REST API connection. I have a request URI. However, this URI always generates an API key that is unique. This is like a signature that is generated on the fly.…
-
B11 vs Extract Cube
Hello in the yesterday's webinar I read that in the conversion from B10 to B11 the Xtract cube have to be replaced with a Extract layout. Is this a manual activity? Or the action is automatically adapted? If I convert a procedure how this action will appear at the end? what shoudl I do? I have thousands xttract cubes,…
-
Filter / select in Data Flow
Hello, is it possible, to apply a filter or a select on a data flow? The source cube has different entities like customer, productgroup, product. Now i want to start a dataflow with a procedure to select or filter one productgroup (fix) and copy the values of this productgroup to the target cube. kindly regards Uwe
-
Do we need to purchase a Broadcasting license separately ?
Hello All, I am trying to Broadcast a report for which i have set the parameters as these in Procedure. its a single step procedure, New Protocol > Reports > Broadcasting and I set the parameters as below. Data view is as below and when i run this procedure for broadcasting i get this I am under the impression that…
-
How to automate unloading a database from memory
Is it possible to automate unloading a single database from memory? I already start and stop the services overnight but I have some databases that are loaded into memory when data readers run just before the working day begins. They are taking up memory even though they are used occasionally. I'm happy for these DBs to…