-
Offset Rules
1. Abstract Offset rules are a type of rule which allow you to reference multiple blocks in the same layout as part of your calculation, they can be very powerful but should be used with caution. 2. Context Offset rules can be very powerful in certain circumstances but should be used with caution due to the complexity they…
-
Rename Capsule or Rename Foldernames
Hi everybody, does anyone have experiences what i have to consider by changing the names of a Capsule or Foldernames? Are Presentations still workung i.e. the Broadcasting of Presentations and so on?
-
Flex Grid - Opening fully collapsed
Note - Ignore this, found the solution! Is there a way to configure the flex grid so when you load the screen it loads fully collapsed to enhance speed?
-
Is it possible to use an RTF cube as the body for a Broadcast email?
Hi! I'm working on a Broadcasting module for a solution and I'd like to let certain users create the body of their emails using data entry. I've always done this with text cubes in the past, but I was wondering if it was possible to do the same with an RTF cube - since the Body editor in the Broadcast area appears to…
-
First and Last Purchase Date
Hi Board Community, I am trying to build a report to show the customers first purchase invoice date and last purchase invoice date. In SQL this would be a simple min/max on invoice date, however, am finding this doesn't work in Board. Any suggestions on how to build this report in Board?
-
Procedure Dataflow
I have a cube at los level and I want to take that cube's values to the planning level of different LOSs. Considering los, sbu, sub sbu and competency are in relation and competency being the smallest and los being the largest. How could i do that
-
Can I specify the position of data label and change the color?
Hi BOARD team, I had a chat as following with primary axis (Bar) and secondary axis (line). I choose to show data label for both. At some months, those two numbers will overlap. Can I force the data label for the bar showing inside the Bar? Can I choose color for the data label? It seems like it is only default to black.…
-
Save Time and Resources with Board
Featuring: Community Captain Sergi Fernández — Business Intelligence Consultant, Holistic Data Solutions SL. In today’s fast-paced business environment, efficiency isn’t just a luxury; it’s a necessity. Companies are constantly on the lookout for ways to optimize their processes and leverage technology to drive performance…
-
Maintain Row Templates for Unbalanced Hierarchies Automatically
We have an unbalanced hierarchy that comprises of four levels for which we would like to apply different formatting in data views at the individual levels. The hierarchy changes very frequently and contains thousands of members that are essentially managed by end users. As such, manual maintenance of a row template is not…
-
Office Add-In losing layout
Hi, we are using the office add in, in excel to link some of our reports with board directly onto one or more excel files. These excel files would contain more than one tab with reports connected to board. What we have seen is that at random occations our reports in excel would stop updating. When we try and view the…
-
How to apply Dynamic selection of yesterday to Layout Block?
Hi BOARD Team, BOARD system had a default entity for Day. How can I use procedure to make a dynamic selection of Yesterday and assign this selection to a Layout Block? Thanks
-
How to show the "%" simbol in Excel Board Add in once exported from the reports?
Hi we are currently exportign reports from Board into excel with the "Microsoft Excel Workbook for BOARD Add-in" option selected. Because this setting does not allow the template to export as well, we cannot see the % signs on spesific rows in the report as we had to add them in using the template functionality. Is there a…
-
How to hide / show a row based on cell condition?
Hi BOARD Team, Is it possible for me to hide the row where all cells are in green? Basically I only want to show rows where there is Orange or Red. The logic for the color alert is If a/b < 0, then it is red. If a/b < 4, then it is Orange. Others are green. I am struggling to come up with a way to only show the row where…
-
Show all values in chart labels
Hey, is there any chance, that we can tell the chart to show all the values of each series regardless of its size? Here is an example:
-
Yearly Cumulated Value + Detail by Year in block
Version 12.6 We have a MTD cube, with a selector of generic fiscal period (1-Jul, 2-Aug, 3-Sep…12-Jun). I have a block with MTD value with "detail by fiscal year" set and "Tme function>Yearly Cumulated Value (fiscal years checked)". No time entity in rows or columns. The MTD cube contains 6 years - all years are 0 amount…
-
How to create a variance on one cube detailed by version
Hi, I am trying to create a variance column based on one cube that is detailed by version. The problem that we have is we have data in one cube by different versions. We have to create a report to compare versions together but we must be able to select any versions which means I cannot create a block reference on teh cubes…