-
How to Find unused Cube
Hi Everyone, I am working on database which has many cubes (almost 900), from the time i started working on this I have came to realize that probably all are not used. So I would like to know probably cubes which were create during development or for testing but are not used anywhere now, which will help me to identify &…
-
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…
-
sum of hours
Hello all. I need your help trying to see how I can model a specific request. I need to create a dataview storing hours (see pictures here below) By row I have the agent, by column the day of the week (m,t,w,t,f,s,s), data are the number of HH:MM the agent worked that day. At a certain point I need to sum all the hours in…
-
Chart Color Block
Hi everyone, Is it possible to change the color of the chart Color block and/or add a 0-line? The red/green division is quite bold and my users are not happy with it. We want to show the 0 line but using "Show Gridlines" just adds all the lines. We only want the 0 line. Alternatively, we want to use more subtle colors in…
-
Bold Font on Row Entities in Layout
Hi Is there a way to make the row items in a layout to be bold based on the same as what you do in Block Formats? I would like the entities in the row to be bold as well in the same way as the cube data: Therefore I would like the Row Total and Grand Total to be bold (and a large font) in the same way that the data is.…
-
Master data changing by year
Hello, everyone. I am faced with a problem. I need to create a database, but in the current system, the entity member names change every year. Example: 2018 -> Product A 2019 -> Product A' 2020 -> Product A'' When referring to historical data, the display name needs to be changed depending on the year. The way I figured it…
-
Picture in "Columd Algorithm"
Hello all, we are working with the Board Windows Client V10.1.4. I will add a picture to the "button". Where must the image be saved? what must be entered under "Column Algorithm"? Thank's in advanced ------------------------------ Stefan Batalia Board Administrator Optibelt GmbH Germany ------------------------------
-
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 ------------------------------
-
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…
-
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.…
-
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 ------------------------------
-
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…
-
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) -->…
-
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…
-
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 ------------------------------