-
Sorting data view with multiple entites
Hello, I have a dataview with two entities by row: - Business - - P&L Line How can I apply a custom sort to the Business entity? It only sorts by Code or by Description, and the Filter -> Sort in data view options only applies to P&L line. ------------------------------ Mark Developer Australia…
-
Broadcast error
Hello dear community, When I execute a broadcast procedure from a batch file that opens Board client, i have this message (screenshot) and the broadcast is not executed. I presumed this may mean that I have two different versions of the board client on my computer but that's not the case. Do you have any ideas please?…
-
Dynamic Time Selections
What is the most efficient way to make a selection based on a custom time range? For example, I want to see data from the last 90 days, or the last 6 periods. Thanks! ------------------------------ Mallory Lindsey Business Reporting Analyst Pepsi Bottling Ventures United States ------------------------------
-
PROFIT UND LOSS STATEMENT: SPECIAL STRUCTURE OF COLUMNS
Hallo everybody! I would like to create an P&L Statement with the following structure: Column 1 to 6: Information to actual month Column 7: row structure of the P&L Statement Column 8 to 13: Information to the cumulated value It should be also possible to expand or collapse the row structure. An Example is shown at the…
-
Profit und Loss Statement: Special Structure of columns
Hallo everybody! I would like to create an P&L Statement with the following structure: Column 1 to 6: Information to actual month Column 7: row structure of the P&L Statement Column 8 to 13: Information to the cumulated value It should be also possible to expand or collapse the row structure. An Example is shown at the…
-
Annual Averages
Hello, I would like to display the annual averages for several years per block and year. How can I do that? greetings Marco ------------------------------ Marco Kuemmel Administrator BI Landkreis Vorpommern-Greifswald Germany ------------------------------
-
Capability to stop big-queries
Currently it is not possible to check all Board Users actions (especially with hundreds of board users working with Board Win Client, Board Web, Board Office Add-in) and the "row upper limit" is not enough because - example - is not checking "how many blocks" the user is inseriting in the Board Layout. There is a very high…
-
Circle alerts in 10.7 web
It seems that using circle alerts no longer works on 10.7 web if the cell that should contain the alert is 0 and Hide Zeros is enabled (default setting). There is no way to show the circular alert unless you show zeros. Is anyone else having this issue? ------------------------------ Jason Febo Architect metrix-CS United…
-
Drillable Headcount Report - don't show grand total or column total
Hi, Apologies if this has been asked before, i'm struggling to find an answer in previous questions. I would like to build a drillable headcount report by week, showing both headcount and FTE KPIs by department. I would like to show subtotals as you drill down the types of headcount and into the department, so i have…
-
chart marker position in webclient
Hello all, does anyone know how I can determine where my marker in a chart is positioned? For Example I like to have the marker above the bar and not within it. Like this: Currently I'm just getting a wrong depiction of it like that: I compared both configurations and they are exactly the same. I can't make out any…
-
Use of WebViewer and PDF files
Hi, I wounder if there is a way to view a PDF'document through the webviewer fuctionality in Board? ------------------------------ Regards Hakon Helgesen Agder Energi AS ------------------------------
-
OOPS. Dataviews break in 10.7
Just wondering if anyone else has upgraded to 10.7 (from 10.6) and had issues with the majority of their dataviews breaking and giving the very useful 'OOPS' error....and been able to find a common cause? We have this happening in many dataviews in a capsule that we've been using internally for about 5 years...I'm hoping…
-
Make an internal referral (multiple options) (100 - 300 points)
Internal introduction (100 points) Instructions: Share with Board staff the name and contact information of someone inside of your organization in a different department that doesn't already use Board and could benefit from using the solution. This could be someone that has specifically shared with you that they struggle…
-
Filter on Dataview
Hi BOARD Community, I have a question on the Filter options. In the current dataview I get the top 10 negative Contribution Margins Countries per Publisher. I am looking for a way to show the top 10 negative Countries overall but still keep the Publisher connection. So in the end I want to have just 10 entries in total.…
-
Your Choice to add a Question or to open a Discussion
Dear Community Members We got something new for you to make it even easier to find what you are looking for: Now, when you start a thread in our community, you can select whether you are beginning an open-ended discussion or asking a specific question: By using this new function, all community members will be able to…
-
Get error for administrator login after update to 11.3
Hi I am get a error for a single user (administrator with windows login). ------------------------------ Charanjit Rai VP Live Technologies !nc. Canada ------------------------------
-
URL in procedures and messages
1. What is your idea? Facilitate the redirection of the user to an external URL, within a procedure. 2. What specific problem are you trying to find a solution to, or what new scenario would this idea respond to? I have a business case these days where we would like to direct the users to a specific URL (a feedback form in…
-
gauge object
How do I add text to the secondary labels? For instance, looking at the below gauge I would like to have the secondary labels read 25% of budget, 75% of projection, without having the user hover over the label. ------------------------------ Chretien Bourque Senior Cost Accountant Medavie Blue Cross Canada…
-
Drillable Headcount Report - don't show grand total or column total
Hi, Apologies if this has been asked before, i'm struggling to find an answer in previous questions. I would like to build a drillable headcount report by week, showing both headcount and FTE KPIs by department. I would like to show subtotals as you drill down the types of headcount and into the department, so i have…
-
How to re-order tabs
Any way to change the order of tabs in a Tab control in the web version? ------------------------------ Mark Developer Australia ------------------------------
-
Column Resize with a Vertical Dataview
Has anyone found a way to resize columns in a vertical Dataview in the web? It was possible in the winclient. We converted a winclient developed capsule over, but now we don't seem to be able to re-size AND get it to save. The column width menu/setting has absolutely no impact, and when you resize in 'play' mode it doesn't…
-
Allow parallel use of Board Web and Office AddIn
1. What is your idea? Allow parallel use of Board Web and the Board Office AddIn. If you try to do this in parallel (open up your browser and use Excel with other layouts), you will receive an error message ("logged in elsewhere"). 2. What specific problem are you trying to find a solution to, or what new scenario would…
-
Data Drill not showing all records
Hi Guys, I'm wondering if anyone has come across this issue I'm having. Board is loading data in fine via the data reader, however we have several finance reports that show the correct numbers at high level in the data tables, however when we drill into the lines there are no records for the current month at the…
-
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) -->…
-
Improve debbuging/running of procedures from Procedure Editor
There is a very frustrating feature of the web interface when debugging procedures. There are some actions in procedures which error when debugging them (ie. 'running' them from the data model Procedure Editor) - even though they work when called from the capsule/screen. These actions break the procedure in debug mode and…
-
RAM cubes
Hi everyone, can someone help me understand the property "In RAM" for a cube? I've different result in a dataflow if I enable or not this property! When I should use "In RAM" and when not? Why I've different output in case is or not enabled? Thanks, Giacomo ------------------------------ Giacomo Fosci BI Specialist GRUPPO…
-
Dataview: "Improvements" in column width management
Hell o! I've seen the official changelog but I strongly disagree with the wording on the following change : "Dataview: improvements in column width management" as it clearly worsen my experience in column width management. The culprit : Resizing columns is a key part of making a dataview, which is one one the most used…
-
Fix cubes as axis in a layout
Hi, I'm trying to figure out how it will be possible to set a cube or algorithm at the first columns of a layout like a layout axis to avoid them disappearing when scrolling down to right. I tried to link two dataviews, one containing the cubes that I want to fix and the other with the information displayed by month. The…
-
Allow Exports/Broadcasts in procedure to use selects
1. What is your idea? The idea is to create a broadcast or export in a procedure that uses the select logic in the procedure overriding the select saved on the screen or presentation. For example if I have a procedure which runs the following steps: 1. Select Oct2020 2. Export Printable Report (pdf) This .pdf will be based…
-
Data Reader: Columns Representing Different Entities
Hello I have a table where the columns represent different entities of a cube. Is there a way to load a cube through the reader that associates different columns as specific entities? Cheers ------------------------------ Jason Ferguson Management Accountant Australia Board Ver: 10.6 ------------------------------