-
Need support for normalize data
Dear All, Currently, i want to create a forecast report. I will explain my situation. Please take a look at below table. I have a part id 'A100' and this part is manufactured in CN currently and will be manufactured in VN from Nov-2018 completely. In this case, i need to create a forecast for CN Factory from Jan-2018 to…
-
Data Entry - doesn't work for all items
Hello, I have a cube that has a Sales Team and Month entity. Data Entry is enabled in order to manually insert values. However, not all of the teams are "enabled" meaning that not for all teams I can write a value (see below). Do you have any idea on how could I investigate the cause of this? Thank you, Cosmina
-
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…
-
How to create a Square Metre Symbol
For me, understanding how to insert a superscript 2 for m² was one of those little niggly things which drags on and on because 'I will google it at some point, but just haven't gotten round to it yet'. Well, I finally got round to it and thought I'd share. * Type m2 * Highlight the 2 * Press and hold the [Alt] key then…
-
Office add-in excel, keep format
Hello all, is there something like @selection for the Excel Office Add In? And how can I avoid reseting the format of my excel sheet when I refresh? KR Annika
-
Filter visibility of rows based on PDF cube
It's possible filter by a PDF cube? I want filter a layout by a PDF cube and see only the row where the PDF is present. What is the condition?
-
Cannot Run Requested Analysis: error
Hi everyone, I'm trying to run a detailed layout but getting error 'Cannot run analysis'. However removing any of the entity, layout is running fine. Is there a way to fix that? Are there any limits in terms of entities/results/etc? Thanks
-
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.
