-
BOARD 11 Randomizer Tool
WHAT WAS THE RANDOMIZER TOOL. To those that knew of it, and before BOARD 11, the Randomizer Tool was hugely powerful, allowing test models of production offerings to be created in as little as five minutes (once you knew the fields and cubes to obfuscate). Simply put, it turns real data into random data. Image 1 shows the…
-
Block(s) copy in layout/dataview
1) Copy&Paste a block is really usefull because configure each one is really wasted time comsuming (ReferTo, TimeFunctions, Format, etc...) as it is possible in Desktop client. 2) Also, copy&Paste block format would save lot of time 3) As now it is possible to copy&paste several steps in a procedure, why it is not…
-
ASSIGN the SAME COLOR CODING TO the SAME ENTITY MEMBERS ACROSS CHARTS
* What is your idea? It should be possible to assign a “standard” color to each entity member at a “capsule” or “environment” level. This coloring schema should be retained across all the different charts those items are displayed in. Therefore, similarly for what happens in Corporate Designer, when a certain item is added…
-
ADHOC Report Builder
The Idea. I would like to ask for the community to vote for the idea of an adhoc report builder for the daily user. I am aware that this idea, in various guises, has already been suggested, most recently by swathi mp in his question here. And here are some others: Adam Elvin 05 Nov 2017 Conditional Display of Columns -…
-
Google Analytics in Board
Hi all, We are bringing into Board some very basic Google Analytics data via the Data Pipeline and SQL (Visit, Bounce, Transactions etc) just wondered if anybody else is bringing in GA data? Which prompts a couple of questions; * Are you doing the same way? * If yes, are you bringing in richer data than above and what does…
-
Alerts in DataView - Not available in vertical Alignment
Hi together, I have created a DataView and wanted do display an alert on the numbers. If the Block orientation is set to vertical, it does not show the alarm. Only if set to horizontal… WHY?!
-
Board Beyond 2023: It’s time to ignite the Intelligent Planning revolution
For the first time in three years, we’re bringing the Board community together in person to discuss all things planning. We’re beyond excited (😉) for a day of visionary speakers, sneak peeks at upcoming product enhancements, interactive solution sessions, and the networking opportunity of the year. Best of all, Board…
-
Relationship
1. Abstract Properly designing and maintaining relationships is essential for a well-functioning solution. In Board’s multi-dimensional database, relationships are a core component of the database configuration. Incorrectly configured relationships can make data partially or wholly inaccurate and lead to incorrect…
-
Experiences upgrading from Board 10.x to Board 12.x
Hi Everyone, I'm relatively new to board and as luck would have it, my first project is to upgrade one of our clients from version 10.6 to version 12.2, with more clients to follow for the remainder of the year. I've read the instructions for upgrading and regression testing, however I am interested to get people's…
-
Board Community Celebrates International Women’s Day 2023
The Board Community invites you to join us in celebrating International Women’s Day (IWD) 2023! This year’s theme is #EmbraceEquity and recognizes that equity isn’t just a nice-to-have, it’s a must-have. A critical component of this year’s campaign is education—recognizing that Equity and Equality, while often used…
-
@Selection on Blocks
One of the major issues we have with trend based dataviews and charts is having to use CY, CY-1, etc for current year and current year -1. This is very annoying to end users and causes us to "hard code" the years into the block header, meaning all reports must be updated each year, month etc. when we use block references…
-
Introducing Board's Community Team
With the recent launch of our new Board Community experience, we'd like to pull back the curtain and introduce the team that helped make this migration possible and successful! It is with great pleasure we introduce our Board Community team. With a diverse background in customer success, content management, marketing,…
-
Display internal Entity member ID
1. What is your idea? The Idea is, to display in the entity section of the database the internal ID of Entity members. 2. What specific problem are you trying to find a solution to, or what new scenario would this idea respond to? Board technology saves any selection on entity members on the internal ID of the entity…
-
Collect and invite marketing data
We need a way to collect data from different platforms to load into Board. Fivetran would be a good option, but there is no Board Connector. Mainly it is about marketing data. What do we pay for advertising for etc? Does anyone have experience on this. An alternative would also be helpful.
-
Extract cube/file to local path
The question below relate to a cloud installation of Board (v 12.4) Is it possible with a procedure (Extract cube) to write the file to a path locally on the user's computer. Shouldn't write the file to Azure Storage.
-
Extract layout excel from drill down in Board 10.7 local and web
In local, I am able to drill down and extract the layout via Excel. I am not able to do the same in the web. The layout from which I drill down consists of a cube (hide) and an algorithm within which there is an image that I click on to drill. Could you help me? Attached are three screenshots which may be useful. The first…
-
BEST PRATICES
Hi everyone, I wanted to put a question regarding the best practice that we follow with regard to masters (e.g., store master) or transaction files (e.g., sales file). E.g., 1) The date format for date code is YYYY for year, YYYYMM for year-month) & YYYYMMDD (year-month-day). 2) There should not be any breakage in linear…
-
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…