-
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…
-
Cart & PinBoards in Web Client
Hi all, I'm missing the "Add to Cart" function in the WebClient and I cannot find PinBoards created in the Win Client in the web. Isn't it supported in the Web Client? Regards, Jörn
-
Write back in cube after data-entry
Hello, i have a simple question: I have a dataview per Month and Values with the option to enter Data. After the user save the entry, i wand to fill a cube with the percent of the total for each month, because i need them for further calculations. Jan 10.000 22,2% Feb 15.000 33,3% Mar 20.000 44,4% Total 45.000 100% I have…
-
POP-UP window
Hi everyone, I think this will be a stupid question, anyway, I'd like to create a pop-up window: by clicking a button (or a dataview cell) I'd like to display a dataview inside a pop-up window. I tried the "dataview options" by configuing a cell as a button and setting a drill to screen, but this open a new screen ...…
-
Exception has been thrown by the target of an invocation in board
My user is getting the following error when trying to open a report: "Exception has been thrown by the target of an invocation in board" I've searched the forum and found no answers HELP!!!
-
Alert on calculated Label seems not to work in BOARD 10.5 Web
I created a label which I used to show a trend arrow with this formula: if(a>0,"?", if(a<0,"?","→")) where "a" is a simple numeric cube, which is also part of the label layout. The result type of the formula is set to text. The formula is working correctly and the right arrow is displayed. If I set an alert on the formula,…
-
BOARD Functionality for Screen Identifiers/Versioning across Capsules?
We're running a number of differing Capsules for different Clients, and in order to assist our Support Desk with quickly identifying where a Client's issue may be, we're wanting to implement a Screen Identifier system, the same you would if you were running and maintaining a complex website (which we kinda are by default).…
-
@Buttons as pager
Please suggest he how to use button/procedure as pager/selector ? Input: I have 10 button/ 10 procedure how can I use it as pager. output: user should get an option to select 10 button ,like sliding 10 options. can select any among 10 buttons.
-
Nexel Crossview seems to be forgetting reference values
Hello All, Since i was using nexel cross-view for creating summarized view of different layouts into one report i observed that reference cell values all disappears when i login to Board again after few hours, when i again go to formulas hit enter it works, sometime i have change reference and then type the previous…
-
Treemap Chart
Hi all, I created treemap chart and I have only one data cube and one axes.I just wanna see my cube's values on my treemap screen like ; But on board; I couldn't add my measure's value inside my treemap charts; Can anyone explain how can i add my values on the screen, Many thanks, Evin.
-
rule
Hi, Looking for a possibility to prevent user from entering decimal values in a data view layout. It's a direct data entry on a double cube, 4D.
-
Nexel function based on different dataview
Hello guys, is it possible to do an nexel function based on a different layout on the same screen? If yes, how? Thanks and BR Moritz
-
Is it possible to do a crossview in a nexel along side a normal nexel formula?
Currently, I am trying to take one value from the home dataview and divide it by the total of another dataview on the screen but whenever I incorporate both dataviews my nexel column becomes blank (please see image) Thanks
-
Nexel Corssview Values disappears after Board engine restarts
Hello Team, We are using nexel Crosview function for displaying value in single dataview from different layouts , its working fine initially as per the functionality but as soon as the board engine restarts all the values are disappeared and we are facing really tough time getting them back on our Crossview again. Could…