-
Drilling from Account Group to Account not working correctly
Hi Community I have 2 entities, for example Account and Account Group. When I drill down from Account Group to Account the results are not the data for the Account Group I am drilling down from but for all the Account Groups. I would expect to see Accounts and a total of -5.554.148. Is there some error in the relationship…
-
Data Changes
Hello Currently we are currently using a SQL data reader and loading data once a day. How do we set up board to load only data changes throughout the day. Thanks Alex
-
Search function in board v10.1.4 (Web Version)
Hi I miss the search function in board v10.1.4. I would like to search for example for an article in a dataview but there is no magnifying glass symbol in the web version like it is in the client one. Can someone help? kind regards Hendrik
-
Outer join in ms sql
Hi I´m trying to outer join tables(left join) in a datareader. I´m an Oracle person so I´m used to doing it in the WHERE clause and that is not an issue in BOARD, but I´m working with an MS SQL database and I don´t seem to be able to change the INNER JOIN to a LEFT JOIN. Does anyone know how to do that? Kind regards,…
-
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…
-
How to print/export several screens in a single printout/pdf
Hi Board-Community, I would like to print and/or export several screens. Result should be one printout resp. one pdf file. In my approach I use a container with "print AS SINGLE OBJECT", Therefore one screen results in one page. Is there any sophisticated appraoch to print /export these screens in one procedure? Another…
-
server-side command in a procedure does not run the script
Hello, I experiment a strange behaviour using the server-side command within a procedure I have two .bat files within the /Board/Job folder * ListFiles.bat * MergeFiles.bat both are called at the same place in the procedure : (without any parameters passed through BOARD). * The first one runs successfully (generates a text…
-
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…
-
Capsule Creation Restriction
peperHi, Is there a way to restrict power users to create new capsule to the root/other folders and only give permission to create new capsules in a dedicated folder e.g in a developement folder?
-
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.
-
Show word document in Board
I have a formatted word document (can be saved as doc, docx, html, etc) and i want to show this inside Board. the viewer on the installed client can show it (as long as the path is accessible at runtime). On the web I need to add this file to the web server somehow. How do i add a file to the web server so that the viewer…
-
How to use entities and relationships in data flow
Hi everyone, I dont know how to use entities and relationships in Data Flow. Can we use it in the algorithms? Can anyone explain it? I dont see it in document. Thank you very much for your help. Thanks and best reagards William Le
-
Export Screen to PDF (Cloud environment and HTML5)
Hi everyone, I need your help once again. I have had this request now twice from customers and I am struggling to find a good solution, export to PDF has been discussed a few times in the community but all entries so far are no options for a cloud server hosted by Board (at least I think so). My customers want to export a…
-
Bar Chart in HTML5 - Cannot click on bar due to hover window
Hi everyone, I am building a reporting for a client at the moment and they want to be able to click on a bar in a bar chart which will take them to a detailed report which shows more information. In theory no big deal, I have set up everything accordingly, but now I am running in an unexpected problem. My chart is at the…
-
Fiscal Calendar in Board
I am have some issues trying to implement the Fiscal Calendar which start in April... Also When a prompt is created can it use hierarchy or trees Example: Year 2017 Fiscal Year Fiscal quarter Months
-
Text Cube
Hi, I have a text cube that is linked to two entities (lease and currency) but not day, month or year. I'm using the text cude to record comments for the entire period in the first report and I would like to reuse the same cude in a second report to display the comments which is driven by the month entity. Is there a way…
-
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…
-
block-specific cell border color within a dataview: how ?
Hi everybody, In a dataview, i try to have different colors (for each block) in terms of cell borders. A parameter for cell border is also nice to have. I don't find where to set this up. I have looked there: * Dataview Menu > Layout > Block configuration > Format: I can set foreground and background color of the cells,…
-
data reader file name substitution variable
We have data files to load that have been prefixed by the Business Unit and Month Year e.g. BU123_Jul.17_SalesDat.txt We have corresponding Month and Business Unit entities in the database. These are available as pagers in a screen. I would like to utilise these to dynamically pass the user selections to the data reader…
-
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
-
What kind of database is BOARD? Graph, relational or something else?
BOARD does some great stuff with the HBMP database technology, but what type of database is it? Is it a graph database? Is it strictly OLAP? I don’t think it’s relational. I’m just trying to understand more about the theory behind it.
-
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…
-
Format kept in the "groupby"
Dear All, How to have the "GroupBy Background" in the same format of the block ? In my attached file (collapse view) I would like to have the total of the first column in orange, then the 3 next columns in red... Thanks for your help. Hervé
-
examples
New here and looking for a few examples of what others have done? Tried looking around but wondering if there is a specific place to go with some samples and ideas?
-
AWS MySQL Connection
Does anyone have any experience connecting to a Amazon MySQL database? I am having difficulty getting it to connect to the datasource.
-
Calculate contract value per month
The question is how we can calculate the value of a contract. We have the value per month, as an example: 12 Months with 100 euros per month. January 100 euros February 100 euros March 100 euros etc. In Board I would like to see as a result January 1200 euro (sum January to December) February 1100 euros (sum February to…
-
Values in Dashboards/charts overlap with the bar
Does anybody here have an idea or already had the same Problem and has a solution for it: We often have the case that values in Dashboards/charts overlap with the bars (see attached screenshot). Our customers are not amused about that fact as you can imagine. We do not have any clue how to influence the chart where to…
-
Read Log Files into a Capsule
Good morning I have a personalized admin capsule where i do administrative jobs like load cubes data and i would like to reads the logs file generate from the import into a screen. do anyone has experience on that matter ? A good example is the task manager screen where you can see e formated log with head columns