-
Nexel - Calculation
Hi, I'm working with Nexel and have to data views in the screen. The last one I'm using Nexel to hget a value from the first data view by having this formula =["Nettkapital;@f;*;*;Range.Vertical] and this works. The main goal is to multiply the "Nettkapital" (Grid Capital) with 1.01. This do noe work in my data view. It…
-
BLOB Cube for Importing Image
Hi Team, We are using Data reader for loading BLOB cube with Name and Image Path. The Images are getting uploaded for only few and not for others. Step 1: Extract entity where name and path is present. Step 2: using the data reader upload the extracted file to BLOB cube After step 2 , we verified the BLOB cube , we saw…
-
Copy capsules procedures form a capsule to an other capsule
Hello all, we are working with the Windows Client V10.1.4. How can I copy a capsules procedure from a capsule to an other capsule? Thanks in advanced ------------------------------ Stefan Batalia Board Administrator Optibelt GmbH Germany ------------------------------
-
How to change position of markers in waterfall chart?
Hello, using the waterfall chart I have a problem with the marker values. They are shown inside the bars and I do not know where to change them to be shown above the bar instead. Because if the bar is very small it is not possible to read the value in the bar, independently of the selected textsize. Best regards, Hannes…
-
Board User Log analyzer
Hi, Is it possible to have a Board User Log analyzer to see how many users and which screens that are most frequent used? The Monitoring of the online users is just an indicate over users that has loged in the system last day. ------------------------------ Hege-Elisabeth Marum Business Controller Agder Energi AS Norway…
-
Server/client command
Hi guys, I have a customer who runs BOARD in the cloud and am trying to trigger a Stored procedure using a powershell or batch file which i would like to run via the server command option in BOARD. Would this be possible? If not, what would be an alternate solution? Your help would be much appreciated. Regards, Ghalid
-
Unable to display at the same time the split per month and the last month selected ?
Hello all, We are trying to migrate our reports from our previous FP&A software to Board and are facing an issue with a requirement which seems to be basic : The requirement of our management is always the same on nearly all their screens : * 1. The user should be able to SELECT the month he want to see (eg April) * 2.…
-
UI Design Document
Hi Team, We are learning now how to design the capsule or layouts for new customer Demo. Do we have any specific design rule book to follow with respect to usability.? Eg: 1. Which is better Dataview or container? 2. Color Scheme to be used? 3. Menu, Tables , Buttons configuration? 4. UI related 5. Any other Thanks Regards…
-
Calendar Object
Can we have 2 calendar object in the screen , each referring to different layout. ------------------------------ Sumanth N R Team Lead SIMBUS TECHNOLOGIES PRIVATE LIMITED India ------------------------------
-
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…
