-
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 ------------------------------
-
Cannot Create a capsule on the web
Hello fellas, I'm tring to create a capsule on the web but I'm having this error. Would you know what's the problem ? Thank you for your help guys! ------------------------------ Fethi ZERARA Consultant Fastcube FASTCUBE France ------------------------------
-
Menu not working in version 10.6.0.3?
Hi, I have applied a "Menu" possibility in a screen for different users with different access to folders and capsules. The target is "Capsules" and position is "Root". This works for the admin user, but not for others (the Power/LitePlus/Lite users), they get the errormessage: "No items to show". Is this a bug in this…
-
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 ------------------------------
-
drill down column width
What configurations are available in Web related to column widths? In web, currently I do not see a way of changing or fixing the column widths for drill downs from Chart and from DataView. Any ideas? Cheers Mike drilldown#, chart#, dataview#, columnwidth#
-
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…
-
Week Ending Description Change
Hello In the database that I am using I would like to update the Week Ending Time entity so it shows WE 04/10/2020 instead of W.41/20 Whats the best way of doing this? Cheers ------------------------------ Jason Ferguson Management Accountant Australia Board Ver: 10.6 ------------------------------
-
Display Graph Entity Names in Legend
Hello Im having troubles with displaying the entity names in the graph, It should be displaying the Role name for the entities. But It repeats the name of the cube. How do I fix this? Cheers ------------------------------ Jason Ferguson Management Accountant Australia ------------------------------
-
Applying rule doesn't work
Hi all, I use a procedure to fill the basic values in my balance sheet dataview. The procedure looks like c=a*b where a is an another cube and b is a mapping cube. This works fine so far. F.e. cube c: Entity "Balance Sheet" - [1]asset a - 100 [2]asset b - 200 I created a rule based on the basic values to calculate some…
-
Runaway abandoned user jobs crashing Board server
Hi, running on 10.6, on premises. Occasionally, one of our Board users will make changes to a data view for analysis the is too complex for Board to return results. They cancel out of the browser screen, but the job continues to run on the server. That long running job affects performance, and over a short time begins to…
-
Cube refresh - restricting user access while rebuilding
Hi, running on 10.6, on premises. When we run our nightly refresh, it takes about an hour to fully update all of the cubes, most of that time is in the refresh of 3 shipped sales related cubes. If a user accessed Board in that window, the data is not accurate since the cube builds are partial and in progress. OPTION 1 I'm…
-
Selections after refresh in web version
Hello everybody, There is a "dangerous" behaviour after refreshing a screen in web version (refresh with the native button of the browser or entering in the url bar and clicking intro), in some capsules/projects after refreshing the browser jumps to the home screen (is not the best option but it is safe in terms of…
-
Rejected rows Log file
Hi Boardies, I am trying to find the log that contains rejected rows, from a data-reader import. I have enabled the Log checkbox. When the data-reader runs, there are some rejected rows that I need to examine. Please can someone tell me where I can find this log file? Thank you in advance, Aicia Meredith-Smith LA PERLA…
-
Hiding Filtered Out Field
I have a list of values that by default I have filtered out "Project". Standard Board functionality has this field turn gray and places it at the bottom of the list to indicate that it's not selected. Because this is an outdated field, is it possible to remove this field altogether from the view using Design Mode? If not,…
-
Upgrade to Board 11.2 concerns
Hello, we upgraded from 10.6.1.4 to 11.2. We migrate database and capsule. The system is now very slow. We have a day version, we created a monthly version, and added a new version. We also used the learn option but performance are not improving. Dynamic select does not work anymore. Several time is going in loop mode and…
-
Custom time entity "Current week" error
Hi Community I have a unusual error regarding a custom time entity. Let me at first comment you that the issue is only regarding the custom time entity "actual week". The translations for the entities in use are below, for a fast understanding in case you don't know spanish: Dia = day Semana = week Semana actual = actual…
-
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!…
-
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!…
-
licencing area
where is the licencing area on board.com ?
-
Column size
Hello, I am a french administrator. I only used Board via the software and we now want to migrate and only use the Web client. My question is the following : how can I change the size of the columns for my differents screens? It is unreadable Thank you, ------------------------------ Abderahman ZAKARIA Contrôleur de…