-
Repetitive DataFlows
Hello all, hope you are fine and doing well! I have following question: Can someone tell me how to easily adapt DataFlows with a similar configuration? Right now I have an entity with 100 items and I'd like to create a comparison cube with that entity (ACT,BUD,FC,PY). Each comparison has its own cube and I like to filter…
-
Statistical functions NORMINV and NORMSDIST
Dear all, to implement a safety stock application on BOARD I need to use these functions related to normal distribution: NORMINV and NORMSDIST. I would kindly ask you: 1. Are these functions available only for Nexel and not for dataflow? 2. I was able to use NORMINV on Nexel but NORMSDIST does not work, is it supported? I…
-
Zero-Based Budgeting
Hi all, I was keen on reading about the topic "Zero-Based Budgeting". Can anyone help me with any study materials or maybe the link to the webinar we had recently? Following is the link, for ref: A New Age of Zero-Based Budgeting (Thursday, Feb 25 2021) | Board Warm Regards Farifta Sanam Bora Business Consultant Simbus…
-
Refresh selection in Board Add-in funcionality
Hello everyone, I'm using v.10.5.0 and I've come across the following problem: I have a layout in the client, with some selectors. I have exported the excel file, which I can connect to Board via Add-in. Then I have created a procedure which refreshes that excel, with "apply data selection" enabled (see image). But the…
-
Data Entry Saving Methods
1. Abstract When saving data entry on a Screen, either the data entry Tick can be used or a separate save button. We’ll discuss which should be used, depending on several different variables. 2. Context Use of ‘on data entry’ triggers and save procedures are valid and applicable in different cases. To determine which…
-
Board Academy not loading in Google Chrome
Is anyone else having problems launching Academy in Google Chrome? I'm on Mac if that makes any difference.
-
Excel drilldown issues
Good Morning Everyone Some of our users are experiencing a problem where they can refresh data from Board in Excel, however when they try and drill into it nothing happens. Have any of you experienced similar problems, and was there anything you could do to fix it? We're using Board 10.0.1 and Excel 2010. Many Thanks…
-
Excel drilldown issues
Good Morning Everyone Some of our users are experiencing a problem where they can refresh data from Board in Excel, however when they try and drill into it nothing happens. Have any of you experienced similar problems, and was there anything you could do to fix it? We're using Board 10.0.1 and Excel 2010. Many Thanks…
-
CONNECTION or CUBE to .csv stored in FILE SHARE drive
Dear all, Maybe some of you have met the same issue: i would like to create a connection or a ROLAP cube to a ".csv" file stored in Shared Storage drive (GUI = microsoft azure) provided with full cloud version of Board (currently using 10.6). I could use the Shared Storage with:* Data Reader to load data in a cube (using…
-
How to calculate Week to Date vs Week to Date LY
Dear Community, How do I accurately calculate Week-to-Date comparisons between current year and last year, for the current week? At the moment, I can only get it to compare current Week-to-Date to the full Week-to-Date previous year. This is incorrect. The question has been asked before but it has not been answered so I'm…
-
Formatting of custom drill down layouts
Does anyone know how to format a custom drill down on Board web client (we are on 10.6). I.e. column widths, table styles, etc. It seems that you can only create and save a custom drill whilst drilling down from a Data View in Design mode and then editing the layout. But this provides no option to apply any additional…
-
Server Command - Batchfile not visible
Hello Togehter, i try to execute a batchfile with server command step. I placed a batchfile in folder /Board/Job, but it is not visible. Is there more configuration needed? Thanks for your Help!
-
Extract all Cubes – Filter Cubes by Entity
Description In Board it is possible to extract all cubes with procedure step “Extract all cubes”. It would be great to have an option to filter the cubes by entity or list of entities. For example I have a database with 1500 cubes. 600 cubes use the entity Planversion. I like to extract only all cubes with this entity. Use…
-
Screen fit for various aspect ratios
Hi, Our masks are built with a custom aspect ratio that is close to 16:9 and we are using fit to width in the mask. Some users have ultra-wide monitors (21:9 aspect ratio) and for dashboards the screen renders completely differently and is no longer aligned. Chart labels are shifted over so that they are hidden from view,…
-
Scroll bars - change their colour, make them more defined/visible
Can you see that image above? That's a Board scroll bar. It is very difficult for users to see, it can be frustrating for them, moving their pointer over the screen hoping to find where the scroll bar is. Is there a way to make it more visible? Can the colour be changed? ------------------------------ Michael Gerrard UNHCR…
-
IDP | Users | Export - the Last Login and Account Status are not included
When I export the list of users from the IDP, I get a nice CSV file. But the columns Last Login and Account Status are missing. Why? Can these please be included. For analysis of users and their activity, this information would be very useful. Or am I missing something? ------------------------------ Michael Gerrard UNHCR…
-
Board MS-Office Add-In
Hello everyone, I just have a simple question, but actually haven't found anything about it here in the community. Does Board's MS Office add-in also work with Microsoft Office Professional 2021? Does anyone already have this in use in this constellation?
-
Subtotal
Hi How to Show Subtotal on table. ------------------------------ Shakti Dubey IT HARBINGER ANALYTICAL CONSULTING PRIVATE LIMITED India ------------------------------
-
Winter Release 21
Hello everyone, has anyone migrated (from 12.1) to the new winter release (12.2) yet? I am very curious about your experiences here... Best regards, ------------------------------ Dominik ------------------------------
-
Unbalanced Hierarchy in formatted report
Hi experts, I would like to know how have you all used unbalanced hierarchy in the reports? I have a P&L structure which I define as an unbalanced hierarchy in an entity. This works fine and shows the correct roll-up. the problem arises when I use this unbalanced hierarchy in a report * In the report, the parents should be…
-
Unbalanced Hierarchy in formatted report
Hi experts, I would like to know how have you all used unbalanced hierarchy in the reports? I have a P&L structure which I define as an unbalanced hierarchy in an entity. This works fine and shows the correct roll-up. the problem arises when I use this unbalanced hierarchy in a report * In the report, the parents should be…
-
Introducing Board's Center of Excellence
With the recent launch of our new Board Community experience, we want to introduce one of the amazing teams that is key to bringing some of the most crucial content and knowledge to all of us. It is with great pleasure we introduce our internal Board Center of Excellence (CoE). This small, yet mighty and talented, team of…
-
Procedure analysis
Would be great if there would also be a procedure analysis to see where procedures are used (similar as entity or cube analysis in the data model section).
-
Series Color Issue
Hello, I have been running into trouble when trying to set the color of a series on a bar chart. When I select the series and change the color, it applies the same color to all of the series. Has anyone run into this issue and found a solution? Thanks, ------------------------------ Matthew Sobon Data Analyst M.T. Maritime…
-
Recording of H&M Retail Store Workforce Planning Webinar.
Hi, I missed the H&M Retail Store Workforce Planning Webinar that was scheduled yesterday. If this webinar was recorded, could it be feasible to forward a link to the recorded webinar. ------------------------------ Vincent Dsouza Business Intelligence System Analyst Victorian Order Of Nurses For Canada Canada…
-
[Fixed] Fix copy/paste in rules
In the web interface, Copy/paste in rules doesn't work like it should. Indeed, it paste the data at the end of the line not at the cursor position Example : The "ctrl+c" : The place : The epic fail :
-
[Released] Fix Search Fields in Rules
The bad boy in the picture refuse to work (tested on 10.6 and 11.2). Please fix.
-
Update: Academy Videos Have Moved
We've moved! Many of our Academy videos previously located in the Academy forums have been migrated to the Board Academy as part of the relaunch of Community. In Case You Missed It Sign in to the Board Academy at https://academy.board.com, and then select a link below to access the videos: Build-A-Board Series Subscription…
-
How to Edit the Max Item Number
1. Abstract The Entity ‘Max Item Number’ is used to reference data stored in a Cube version. It determines how the data pages are physically stored and influences performance as much as dataflow execution. 2. Context The amount of master data will increase during an application lifetime, so having a review process of the…
-
How to show total using Rows & columns
Hi, We want to know how to show only total columns using Rows & columns function from top left of screen. Table data have budget and actual. Green cell is actual, the white one is budget. When we use Rows & columns function for table of half year or quarter, the total value shows wrong. Specifically, when data has one type…