-
On a BOARD cloud environment is there a variable available to identify whether the instance is the S
On BOARD cloud is there a variable available that could identify whether the instance is the Sandbox or Production environment? I would like to use such a variable to control some extracts (via a procedure) from BOARD to the appropriate Azure folder . I have thought about creating an info cube to store such information but…
-
Layout algorithm in rows / columns
Hello, I would like to know if it is possible to build a layout using in rows the algorithm. I always use layouts like this with algorithm in columns: Layout configuration - Data - Axes by row BU Layout output I would like to have as output: Is it possible? How I have to configure the layout? Best regards, Gabriele
-
Installation details
Our organisation has just signed up as a partner. I have completed the initial courses and am looking to move onto the exercises. My question is what version of Board should i be downloading and installing? Regards, Andrew
-
How to create a report with several cubes grouped in lines?
Hi, In Excel I have a report that looks like this: What would be needed in board in order to create a similar structure, where the different cubes are over each other (by rows) instead of side by side (by colums)? BR, Ray
-
switch board version 9.0.4 to 10.1.4
Anyone out there who can tell me something about the update from version 9.0.4 to 10.1.4? Maybe some information about problems and their solutions, where you have to look for and what you have to do that the reports are running? Thank you! Hendrik
-
Change web interface
Hi, i was trying to change the HTML5 interface, trying to customize the ribbon bar and web landing page login. How can i change those? I have been mentioned these can be configured and changed but was wondering how Thanks in advance,
-
Why aren't my percentages correct for the Total columns/rows?
Hi I'm a fairly new user of Board, so this might be something obvious - I've been building financial reports, but with my percentage calculations, through using rules, the percentages are correct on the data columns, but incorrect on both the total columns/rows. Values are all divided by 1000 to get $'000 for my financial…
-
Export pdf Board 10.3
Hello, I'd like to know why i'm getting this error when i try to export a PDF document from a dataview! i have to mention that i'm getting this error on my App_data logq :
-
Upgrade to 10.3 & IIS
Hi Guys, I've just updated a Board server to 10.3 and I'm facing an error when trying to login using the web client : I have followed the steps from How to setup Microsoft IIS with Board Server 10 doc, so I'm not sur what I did wrong. Does somebody can help me please ? Thanks !
-
Excel Export Rich Client/ Windows Client
Hi Together Actually we have the issue, that when I export in our test environement a data view to Excel, just a few rows (really random) will be exportet. But not all of the dataview. Is this a known Error with the Board version 10.3.0.50803? This happens only in the Rich Client. It's a Dataview with 2 Entities in…
-
Is it possible to use Data reader without creating Entity, Info cube and Relationships ?!
Hello Team, I was just wondering how awesome it would be if i can use Data Reader, Connect to my SQL Database > Pass a Custom Query and see entities and info-cubes, dimensions and measures gets created. It is possible by any chance ?! or we compulsory need to create entities first, info-cube, relation ship and then use…
-
Dynamic selection not working
Dear Community, I have a problem when I do a dynamic selection on entities. For example, the entity "Enseigne" is not empty and there are cubes that are structered by this entity but I can't find them in the list of cubes below. I have the same problem on all my entities of this database. Do you have any idea about this?…
-
Not valid characters - how to fix?
Hello in some TXT files used to fed BoardI have some characters that are not recognized. I know that I can do something in the source data but for now I jsut want to fix the issue replacing such characters. Setting a formula in the ETL is seems working but when I run the data reader it does not work see the picture can…
-
Setting Privilege?
Hi All, Can application setting privilege user screen access?
-
Budget data with different dimensionality and granularity
Hi, how can we budget data for measures having different dimensionality and granularity? Consider some commercial and distribution cost calculated based on % or mileage Commission cost, for example, are a % defined by customer (or by product or by aggregate entity like channel or brand) and data entry form should refer to…
-
Date Cube-Calendar function in Web
In the desktop version of board, if you have a cube set to "Date" a small calendar will pop-up when doing data entry. I don't see that calendar in the web client. This isn't a huge deal, but does anyone know if this function is available at all in the web client?
-
blob export
Hi, is there a way to export (download) files which are uploaded in my blob cube into to a specific directory trough a procedure? Regards, Jörn
-
Nexel Calculation Problem
I am trying to use COUNTIF in nexel but it is not giving me what I am expecting. The formula is as follows for each block in the Priority column: - =COUNTIF ( [@f;*;Range(1:7)], "<=" & [@f;1;*] ) =COUNTIF ( [@f;*;Range(1:7)], "<=" & [@f;2;*] ) =COUNTIF ( [@f;*;Range(1:7)], "<=" & [@f;3;*] ) =COUNTIF ( [@f;*;Range(1:7)],…
-
Change capsule database  doesn't work
Hello, I want to duplicate my environment (capsule and database) so I copied and renamed the capsule and the database. Then I opened my new capsule and changed the database to the new one. but it didn't work for me. All screens still pointed to the old database and what I found strange is that some procedures are pointing…
-
BOARD installation support
Hi I'm new and i have recently installed BOARD, but i have a problem. I'm not able to do my first access with the client. Can somebody help me?
-
Data selection Entity filtering
Database security: Data selection Entity filtering, Does anyone know why/how I can use the Exclude button? no matter what I do its always unavailable.
-
How to change where x and y axes meet?
Hello, Excel graphs have the option to change the axis value i.e. where the horizontal axis crosses. How can I achieve the same in Board? I can take off auto-range and set my own but the x-axis value remains as zero. Thanks, Ben
-
Adding an entity as block in layout
Hi all, I've to add multiple entities as blocks because using them in axis is exceeding the limit of around 2 billion rows, which is causing layouts to not load. Dataview has data for 24 months and when I'm adding entity as block, the same is shown separately for each month. I heard we can use 'Detail by' to show it only…
-
Not able to save or create procedures
Hi I am creating procedures and was renaming a few. Then I was suddenly not able to save the one I was working on: "The server is not responding or does not trust your user´s domain. Please check your connection settings" I can not create a new one and I can not delete one either but I can run the procedures and the…
-
Refer-to + rules?
Hi all, is it possible to use the refer-to in the layout and have the cube take the value of the rule that is used in combination? Say I have a cube a, with a rule "measures" (in functions) and also a "refer-to" to a value that is computed in the rule. In my case the result is empty. How'd you do that? BR, Ray
-
Data Picker -
Hello all, today i started to familiarize myself with the topic nexel and data picker. Now I tried to enrich values from one cube with a column from another cube. Here I come also fast to a result, which I cannot explain to myself however. The dimension of the value seems to overflow. Can anyone give me a hint which…
-
Can I deactivate column algorithms calculating "live"?
This may sound weird! But we would like the column algorithm to perform after we have saved the data entry so the figures in one column remain the same while planning
-
Problem of creating new relationship with a new entity
Hello everyone, I have an entity Client that is linked to an hierarchy of entities ( the hierarchy contains 6 successive levels) What I want to do is to link a new entity ( Enseigne) to the third level of this hierarchy the entity Ensiegne is the most detail level in the new relationship. How can I apply this solution in…
-
Time tree
Hello community, I have a question: My time axis is as shown bellow Periode Mois contain M-1,M,M+1. I have created a procedure that we run at the beggining of each month to bind M with the new current month, M-1 with the previous one, M+1 with all the coming ones, but the entity Day is not updated, do I have to create…
-
Mapping in Board
Hi, i'm quite new in Board and i'd like to know if I can create a user interface for mapping a general ledger. The requirement come from a customer that is asking us to mantain a P&L in BOARD. This will require, between others features, the possibility to create and mantain different P&L schema (in Board). Once the schema…
