-
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…
-
Substitution formula with an entity code instead of the description
Hello all, I know that we can use subsitution formulas to obtain the selection of an entity: However, are there subsitution formulas to obtain the same information, but using the code in the formula instead of the description? For example, for the entity: - code: "E_0000000018" - description: "Customer". Today I use the…
-
Unable to install Office Add-In with Microsoft Family and Student 2010 ?
Hello, When installing Office Add-In with Microsoft Family and Student 2010, I got the following error message :"You must have Microsoft Office 2007, 2010 or 2013 installed to use the product" .... How to make it work ? Thank You Patrick Cailly
-
Board Broadcasting as scheduled task
Hello Community, I set up the Broadcast functionality of Board to one of our clients and now we would like to schedule it to run every day. So, I create a bat file using the BoardWinClient.exe syntax. The script works find it sends emails with excel files attached. The problem is when I set it as a scheduled task in…
-
WinZip extraction error !!
* Hello everybody, It is the first time I raise a question .... so I welcome feed-back .... Thank You * I was upgrading to the latest Board version the B10.3.0. Following the download and the ZIP extraction into C / Program Files / Board then I got the error message from WinZip "Impossible to deal with "Setup Client…
-
Exclude item in a selector
Hello! Is it available a feature within a selector that allows to select all items but one? Something like the "Exclude" functionality of the Select function, but available also for the selector. Thanks, Emanuela
-
Disabling data entry on totals without disabling the total display
Hi all, Everything is in the title: I'm looking for a way to disable data entry on a total without removing the total itself. The dataview is a basic table to enter data at the physical cube level (no use of split & splat), and we would like to display the total of 3 lines without letting the user modify the total directly…
