-
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…
-
Extract / import blob Cube
Dear Community - this question is coming from @Oliver Etterli, can anyone help? We are using a specific blob cube to save excel files on it. I created a procedure to extract the cube to a specific folder. It saves the normal txt. file and also the uploaded excel files. Now I want to import the cube (in our case from the…
-
Generic Quarter
Hello, We need to set up a Generic Quarter custom time entity and I have followed steps used for a Generic Month setup. I exported the quarters cube and read back to assign the 28 real quarters we are tracking to the four generic quarters I have defined. However, when I go to use Generic Quarter in a layout axis the error…
-
How to Copy Formatting Setting from a Dataview in Board Web Client
Hey Guys, I need to rebuild a bunch of dataviews in the transition to the web client. In order to save a bunch of time I am wondering if there is a way to copy all the formatting settings (Column width, position, font size etc) from an existing dataview in the web client. Thanks, Dylan Fitzmaurice…
-
Performance Testing for Applications Developed in Board
Hi All, Could you please share your experience in Performance Testing of the applications developed in Board? What tools were you using, how you executed it, any other relevant information etc. Much appreciated! Thanks and best regards, Verica ------------------------------ Verica Milanovic Delivery Manager ALITE…
-
merge data from multi data source
Hello I want to merge data from multi data source. the replace option in datareader clear the Infocube cells so not suitable for import multi data source. I have two cubes, 'tmp' and 'data'. I made the data reader loading data from data source to 'tmp'. and I made the data flow procedure. Datail is the following, block A:…
-
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.…
-
"Export data to excel in flattening mode" missing from dataview menu
Hi guys, Need help. I am using v9.1.0. How come I don't see "export data to excel in flattening mode" option when I do right click? Is there some settings I need to do in server? TIA!
-
SQL load, error log
Hello All I get rejected items while loading data from a SQL table. I have ticked the log file option but I cannot see where the log file is saved (Using BOARD 11 - Cloud) I looked at the logs on the board cloud administration portal but cannot see anything under SQL logs. When I load from flat file it generates the log…
-
NEXEL on Web
We recently upgraded to 10.6 and I had a dataview with a lot of cell based deep entity nexel formulas, pulling from other columns (blocks). I accidentally deleted an entity member. On re-adding the member I can not find how to re-add the nexel formulas associated with it. This was very easy in the client version. How do…
-
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…
-
How to change the header of a dataview between forecast and actuals
Hello everyone, I am building right now a 3+9, 6+6,... forecast and I want to change the header of the dataview accordingly to forecast and actuals (e.g. 3+9 forecast first 3 months actual, last 9 months forecast). The cube can be the forecast cube for both actuals and forecast. It is just necessary to display the header…
-
How to show Top 11-20 Entity Members
Hi everyone, I have to show the range 11-20 Clients by turnover in a chart. Is there a dynamic way to do that, without a procedure but using layout functionality? Thank you, Chiara ------------------------------ Chiara Fabris Consultant KVALUE SRL Italy ------------------------------
-
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…
-
Dataflow to Cube with Extra Entities
Hello I currently have multiple cubes with specific data that I want to populate into a single cube. The issue is that I want multiple cubes to flow into the single cube and be represented as different entities (e.g Opening balance, closing balance, Inputs, Outputs) I am unable to find a way to Dataflow the 'Inputs cube'…
-
Time function doesn't work
Does anyone know how to deal with the fact that enabling "Time function" does not work? The dimension of sales cube is Month. When time function enabled, the data will be lost. Board version is 10.6.3.40939 Has anyone else had the same problem? And is there a solution? Thanks, Shuyu ------------------------------ Shuyu…
-
Additional calendar in Time Range
Dear All, I'm currently working on a customer context that needs 2 different calendars:* One starting in Jan (FR) * The other one starting in Mar (DE) First, I was wondering if you already met this request and how Board has been set up to deal with:* These 2 calendars (same time range entity? another cube? date cube? make…
