-
Creating a metric in board
Hi all, We have only just started using board so this may be a pretty basic question but any help/guidance would be very much appreciated! In order to get an understanding of how Board works we started with an example. In our example we are working with product groups, products (each product has a corresponding group) and…
-
Using Date Cube as a Time Entity
Hello I've some peculiar report requirement that has to be done in BOARD. I have 2 cubes, let's say cube A holds an transaction amount value, and cube B holds a transaction payment due date value. So the data type for cube A is double, and cube B is date. The cube B data is from a calculation that has been done inside…
-
ASCII Datareader file location
We've recently upgraded a client from B9 to B10 and we now have an issue where an #ASCII #datareader that works in B9 no longer works in B10 because it cannot find the file which is in a different network location to BOARD. The file is saved to the 'finance' network drive, and in the B9 (production) datareader (below) you…
-
Export DataView in Excel: what about alerts?
Hi all, just a question regarding the export in excel (flattening mode) of a DataView. In Board Client if a User performs an export in excel (by right-clicking on the dataview and then clicking on "Export in Flattening Mode"), the generated excel file will not show all the alerts actually shown in Board's dataview. In…
-
Not wanted behaviour of Export Excel Flattened
Hi all, we are currently struggeling with a function (or bug :-) ) with the export of a flattened excel file. WHAT? We got a procedure, which has nothing more in it then two info messages for the user and the function Export Excel Flattened (see attached). The screen which should be exported has a P&L dataview in it, which…
-
CSV inbound data with multiple columns per product
I have a CSV file, which contains inventory levels and stock movements by location. The file is structured that each line contains detail by location, with multiple product headings in the columns and the volumes then in the row. How do i go about mapping this to the various entities? I have set up a product, movement and…
-
How user will upload a file ??
Hi, I want to give an option to user to upload a file (he will be able to browse to a specific file he want to upload). Helmut HeimannOliver BeirneSimon Scullion
-
Use webclient and desktop at the same time?
Hey, is it possible to use webclient and desktop version at the same time? Or will it usually lead to user- oder licsenseproblems like getting blocked/banned (like formerly using to instances of board desktop)? Or is it a question only my office it can answer :-) ? Cheers Hannes
-
Dataflow processing time - what is happening under the hood?
Hi, apologies for this being a bit long but I really want to know what is happening 'under the hood' in this instance to make two almost identical dataflows take very different lengths of time to process. I discovered the following when looking to speed up a procedure (now that a client is finally on B10). A dataflow was…
-
WYSI (not) WYG - labels in Panel Containers on Web
Has anyone else encountered a problem with how labels are displayed (in relation to each other) when they are in a panel container - where it looks fine in Desktop, but in Web the positioning goes 'to pot' ? Trying to use labels as containers for text, some with borders, and one with an image. Outside panel container, each…
-
unselect master
Hi folks, is there any possibility to unselect the master-function. Once I have selected one item by unsing the master-function I don´t want to scroll down all the way to hit total again, but using a "Unselect" or "Deselect" function/procedure instead. I´ve tried the "Remove Selection" in the procedure already, but still…
-
GVA Introduction video
I was asked by my company to put together a short high level video demonstrating three aspects of our external client tool. Whilst discussing this with Andrew Rae, I found that I could not share with him the content and so decided to share it here for all to see. I welcome any feedback and opinions. At the time of…
-
how to make bar chart columns with different width?
Hi, right now I have this type of chart: And I'd rather have it look like this: The idea is to have bars with different width in order to put some behind others and still be able to see their value Is this possible at all and if so how? BR, Ray
-
Align cube from ROLAP version
Hi, is it possible to refresh the aggregated versions (align) of a cube with a ROLAP version that is on the lowest level? BR, Ray
-
enable broadcast / mailserver feature
Hi board members, we would like to use the mail function in board. I tested it with several smtp accounts (e.g. gmail) and still got the same useless error: "Procedure usermail failed" (without any further log informations). Are they any hints and tips? Best Paul
-
how to create bar charts with several stacks?
Hi, I would like to create a bar chart with many stacking groups as in the following example: Right now there are two stacking groups - combine by stack and combine by stack100. I don't see the option to have put some elements on the first stack, then combine others on a second stack and so on. There would be the…
-
MXC Cube - No Totals
Is it possible to get a grand total of rows and columns when using an MXC Cube? I want to understand MXC cubes more. One thing I have found is that I cannot get row and column totals when using an MXC cube and so have to create a duplicate of the MXC cube, setting the datatype to DOUBLE and not MXC. I then have to create a…
-
Is it possible to "drill to screen" as an action of a procedure?
Hi, Using the drill to screen action I'm able to set a selection for the target screen. As procedure action there's a "Apply selection to current screen" that allows to make the selection for the current screen. As a second step I can use the "Go to screen" action and go to the screen of my choice. The disadvantage of…
-
Extract layout to local machine
Has anyone been able to extract a layout (in csv) to the users local machine rather than the BOARD server? I've tried a few things with no luck so hoping someone else can help. The client's current workaround is to map the drive with single folder access on the users machine to allow them to access the file so they can…
-
Full RAM Mode / Benchmarking : how much time does it take to load your DB in RAM ?
Hi everyone, I would like to do a bit of benchmarking to understand better our performance and look into possible infrastructure improvements. My current issue is that we have large databases (typically 50Gb) that takes a lot of time to load into RAM when used the first time. Usually this takes between 20min and 40min. So…
-
How can I change all screens with one selector in my master screen?
Hello all, how can I change all my screens in the capsule with one selector in my first screen from Jan.18 to Feb.18? Our standard sales report has 15 screens with different dataviews and charts. I don't want to change each month each screen to the next month. I want to change the selector of my first screen and all others…
-
Color coding in treemap diagrams
If I want to display the following data in a treemap diagram, I encounter a problem: The scaling in the Treemap object is obviously correct. But, in my opinion, the color coding is faulty (or at least not comprehensible/understandable for me). If a treemap is created from the data table at the Top, the color coding (an…
-
Upcoming BOARD versions
Is there actually a roadmap showing which features, functions and/or changes are planned for the upcoming versions of BOARD? I am particularly interested in whether the large number of suggestions for improvement that have also been submitted via this forum are taken into consideration.
-
Performance trade-offs : 128 bits sparse versus dense and 64bits sparse ?
Hi all, everything is in the title: very often when designing cubes or cube versioning, I have a choice between these two kinds of structure: - Entity A (D), Entity B (S), Entity C (S), Entity D (S), Entity E (S) => Smaller physical cube size but 128bits sparsity file. - Entity A (D), Entity B (D), Entity C (S), Entity D…
-
Can i copy/paste data from Excel into BOARD?
Hi, would it be possible to copy data (or a set of cells/a range) from Excel directly into BOARD? i need to feed some data from excel into a planning table and i am not sure this can be done. Are there any logics to be considered? Thanks
-
Passing values - no CSV in here please
Hello BOARD community. I wanted to contribute before I asked a question but this issue is perplexing and I really want to know if it can be achieved. I want to disseminate values of a cube to other cubes which have the exact same members but use differently named entities and live as parents in other trees. I do appreciate…
-
How to query active directory from Board ?
Hi everyone, I am currently looking for ways to import in a Board database a few key information about our users, coming from Active Directory. Basically, our user names are email addresses, and I would like to use AD information to associate the location, company, manager name, etc. to our users. This would be very useful…
-
Load CSV using ASCII when there is missing data
Hi, I receive a daily CSV from a third party. The first row is the column header, the first 5 columns always have data and the next two columns only occasionally have data. When I load using ASCII data reader, I can't load columns 6 and 7 because the first row of actual data is almost always blank for these columns. If I…
-
Is the Cognitive Space a game changer?
Hi all, what do you think about the cognitivespace? What use cases do you see in existing solutions and in the future especially for the nlq (native language querying)? How do you explain and demo this to new / existing customers? Do you see the need to change development guidelines like using prefixes to categorize cubes…
-
Conditional display of columns on a dataview
I have this dataview and I would like to find a nice way to hide/show the 3, 6, 9 month columns without having to go into the layout and select the hide block option. I started off with a small data entry cube so that I can place a tick to decide which columns I want to show but I can't find a way to have that affect which…