-
rule-based Total calculation in P&L
Hi all, I want to get a total column based on rule calculations (f.e. sum or avg) My Layout: Cube a - hide. The Cube contains the actuals. On the cube is applied a rule to calculate some positions of P&L. Cube b - hide. The Cube containg the plan values. Cube c - hide. Actuals total by month. Algorithm d - if(c<>0,a,b) -->…
-
Multiple Dec Digits Options
Hi all, I'm wondering, if it would be possible to show different number of dec digits for one entity. E.g. cube a with entity x (values a,b,c) and month: JanFebMara1,1231,2341,456b-2,43-4,34-6,34c1,55,42,1 The value "a" must have 3 Dec Digits, "b" 2 Dec Digits and "c" 1 Dec Digits. For value b would be nice to use…
-
Getting data into BOARD with different granularity
Hey there We are currently setting up BOARD as a reporting tool in our company. We use v10.6. We are trying to get our sales budget data into board to compare them with our actual data. Thus, there is no data entry or anything at that point. Unfortunately, we have encountered a problem: Our sales budget data comprises…
-
Conditional Calculation and formatting
Hi all, I have a dataview with KPI as row and month as column. I created two different cubes with the same structure: Cube A with actuals and Cube B with the plan data. I'm looking for the possibility in board to automatically switch the cube values when the new month begins. Means as soon a new month begins (f.e. Sep 20)…
-
Commentary Field?
Hi, I have a layout where I have a SKU entity as my Row and Sales and Margin data cubes as my columns. Is there a way to add a "Comments" (as a column) field for each SKU where I can enter comments, and then each time I review this screen (or anyone that views this screen) can see the comments for each of the SKUs? Thanks!…
-
Design reports: formula for "Right" side of a cell
Hi Board Community: I'm designing a report. I have a column of info that has a code like this: 1021981.001.002.003. We call this entity "Subworkplan." I want to create a formula (or algorithm?) that will show me the right 11 cells, of what is in this column. For example, show me 001.002.003 in the above example. In the…
-
Printing a presentation to pdf landscape
Is there a way to change the default orientation when printing a pdf from a presentation? I'd like to use this for our financial package and have to generate paper copies for some of our leaders. ------------------------------ Ian Bradley VP Finance (CFO) T&S Brass and Bronze Works, Inc United States…
-
Code and Description in two different columns
Hi All, I have an entity "Material" with Code = ID and Description = Name. I choosed the option "Display Code&Desc" in my dateview, to display both. When I export the report to excel I get one column with Code and Description together. Is there any possibility to get two separate columns: one for code and one for…
-
moving total column
Hi All, I'm wondering if here would be a possibility to move the total column. I have a report like below: Material | Day1 | Day2 | Total and I need something like this: Material | Total | Day1 | Day2 Is it possible? Thanks! Regards, Lina ------------------------------ Ellina Mnikh Controller Germany…
-
Mapping/ Join SQL and CSV Data
Hi all, I'm quite new in Board and would be happy to get an advice to my topic. I use ASCII Data Reader to get the inventory data from a csv. To get some additional information like material description I add a database table Material via SQL protocol. Both of them have a common column calling Material code. I would like…
-
Using new MS Edge with Board
Hello I read in a discussion that "The recommended browser to use with Board is Chrome, using a different browser may well cause some issues." We use latest version of Edge, Chrome is not provided and maintened by our corporate IT. We still use Board Client, and plan web migration in the time being. My opinion is that…
-
Repeat Parent of Nested Items - Like Pivot Table
Hi, I'm a new Board user. I have the following Layout that I'm doing in Excel-Board add-in. Under the By Row, I have our company's categories and each customer under that category (i.e. Toys -> CustomerABC). I'll be linking this table to another tab in this workbook where I need to pick up this combination via a sumifs. Is…
-
Opening Multiple Instances of Board
Hi all, How do I open a second instance of the Board client (ver.10.3)? Should be easy, but it's just not happening - I'm almost embarrassed to ask :) Thanks ------------------------------ Andrew ------------------------------
-
NEXEL writeback not working
MAXIMUM URGENCY Hi everyone, I have a problem concerning the Nexel writeback. As you can see from the picture attached (which is the Nexel layout shown in the debugger), the procedure enters the writeback with the proper selection, therefore the layout is not too big. It writes correctly on the target cube but then, after…
-
How Do You Display Percentages on Pie Chart
On a Pie Chart is it possible to display the percentages on each slice of the chart.
-
Set Data Entry to All Row
Hello, I want to set a date in data entry. I just want entry only once, and the another row automatically filled based on entry the first data. Can BOARD possible do that? and How? Thanks, Best Regards
-
Read Only cubes and data readers
If a cube is read only as configured on the Database Security for a database profile is it so that in a procedure that clears will work (clearing all cube data regardless of entity access the user may have) but that data reader will not load anything into the cube? We are seeing this behavior but somehow I'm surprised by…
-
Office add in for Office 2016/2019
Hello all, the IT department in our company will update the Microsoft Office to the Version ...2016 or ...2019. We have the Board Version v10.1.4. The clients are connected with the web client. Is the office add in from Board compatible with this office versions? Thanks in advance Stefan Batalia
-
Board running in faulted state
One of our users created a fairly complex rule that when attempting to save threw a couple of errors in the calculations. In so doing, this user got an error that the client was running in a faulted state and they should restart the client. After they exited the system, I entered Board and attempted to first modify the…
-
Best Practice: Web Client Presentation Mode
Dear all, One of our customers is a big fan of the presentation mode in the web client to save and share custom reports. Practically what happens, is that they create a report from scratch using the layout builder and save them in a presentation. However what might happen is that they are happy about a custom report, but…
-
How can i map addresses to (latitude, longitude) coordinates?
I have a dataset I would like to visualize on a map. I have addresses for each of my datapoints, but I need a way to convert those addresses into latitude and longitude coordinates for displaying on the map. Does anyone have tips or an approach to lookup (latitude,longitude) coordinates from addresses? There are free web…
-
Server Saving Policies
Does this article board-server-saving-policy ok the KB also apply to the webclient? We have a client who requires to manually enter quite a bit data on a daily basis, but in very remote locations using satellite connections, with a roundtrip latency of 700ms. We've been testing with this latency applied and it has…
-
Design : what Layout for just a Key Value to restitute ?
Hi, I have a simple question about design on Board 11. I'm trying to duplicate one of my BI app to test the tool (reporting + scorecarding). Unfortunately, I can't find a simple Layout: the label (or idk its name in Board). Actually, I would have liked to restitute only an entity value (for example, I have an Entity "Age",…
-
Is there a good instruction guide on how to start using Board as a user to create dashboards and rep
Dear all, Is there a good instruction guide (webinars, trainings, docs) on how to start using Board as a user to create dashboards and reports? Is there a german documentation for Board available? Thanks in advance for any help
-
decimals
Hello, I am loading a CSV file (utf-8) with 2 decimals to fill a cube. On the reader and its ETL, the decimals appear properly but once the load is done they don't appear in the cube. In this example, the cube contains the value 2602,00. In my other CSV files, I see that the decimals are separated by a dot instead of a…
-
Dynamic filter on dataview
Hello, I have a dataflow that contains revenue and costs for my projects. Is it possible for users to filter dynamically on this dataview over several cubes? For example * one user only wants to see projects that have revenue greater than 2.000 and total cost greater than 1.500. * another user wants to see projects that…
-
Dates format EU vs US
Hi Community our server is in Italy, with local settings dates in reports are viewed in the format dd/mm/yyyy Some US users would like to view dates in the format mm/dd/yyyy Is it possible to do something locally, without affecting same reporting when used by EU users? thanks
-
Month selection based on a Start Date and End Date
In order to create a Project (i.e. promotion) management function (which allows end users to add and edit promotions in Board), I've created two Date type cubes for a project Start Date and End Date respectively, which contain only one dimension - Project ID. The requirement is after both dates are entered by users, the…
-
How to sort by a value for a axes combination in DataView
As shown in the screenshot below, we have a Sales cube and Budget cube, which have the same dimensions - Item, Area, Month, UoM. We tried to calculate the Severity (i.e. bias) and present the data in a flatten dataview showing Severity in descending order so we can find the most problematic Item/Area combinations as shown…
-
Alignment and hierarchies in Board 11
Hi all, as in Board 11 the engine is taking care of the versioning I was wondering about the following scenario: We have an entity customer and a second called customer group. They are connected in a hierarchy. Unfortunately customers can change customer group. In that case we reload that part of the tree. Now if a cube…