-
fill empty cell
Hello everybody, I have a cube where I would like to be able to change amounts per customer per date. This functionality requires me to fill in certain fields from time to time, which are still empty. I have turned on split&splat and activated a partern based allocation on the cubes. As soon as I try to fill in an empty…
-
Joining Tables in a Data Model
Hi, I am a little bit confused, I started to work on Board but the last version is quite different from the older one. To load a cube (number of employees per year), I need to join tables in my data model. I can't find how to joint, I suppose it's in the Data Reader but I do not undersand how to do so. I find this on Board…
-
Database object audit
Is anybody aware of the optimal way to get a list of DB related objects e.g. entities; cubes etc. Likewise for capsules and their associated objects e.g. db's; screens; screen triggers; procedures etc.
-
Extract Year from Date Column in the layout using algorithm.
Hello all, Is it possible to extract year from Date cube (the First Column in the Image) by using trim, Right/Left, Year function ?! by creating a Column algorithm in the layout itself ? I am trying to get that and used various combinations of the same but no luck. can any one please guide ?! for example: In the image…
-
Exception has been thrown by the target of an invocation
Hi All, I tried to open cubes view, but i got this error messange. Do you have any suggestion to fix this issue? Note: It happens after i remove a redundant relationship and entity. The entity is indirectly used in some infocubes. exception has been thrown by the target of an invocation. Thank you very much Willam Le
-
Pending Data Entry alert message in Web Client
Hi all, When working in the client, if the user inputs a Data Entry but forgots to save it, an alert message appears asking about saving the pending Data Entry: However, when working from Web Client no question is made, so the user goes to another screen and loses all modified data. Is there a way to configure this alert…
-
Remove commas from Web presentation
I am working with a report where we are bringing in the natural account number into the data layout. I want the natural account number to be treated like a text field and not present with any numerical identifiers like commas or decimals. When I view the report from the board application this field appears fine, but as…
-
"An error occured" in BOARD Web - How to determine the cause
Hi, I am currently completing some user acceptance testing with an application I have developed in BOARD 10.5.1 (web) and the user today experienced an error. They were making some data entry and clicked a 'Save' button (which has a procedure sitting behind it) the following popped up after appearing to do some processing…
-
what is property tab in dataview
can someone explain me visibility, inverse, transparency in dataview layout properties tab
-
How to display only one column in a "show-all columns" dataview
Hi all, I'd have a question about to display only the first column (the first month) in a dataview with the entity month in column and the show-all column selected. The dataview is composed of several cubes that I want to display every month, I need the “show-all” cause the data entry must be possible at each level by the…
-
Cannot load ROLAP date Cube with format DD/MM/YYYY
Hello, We have a Rolap date type Cube and we try to load it in a table which field date type char(10). We need this date with the format DD/MM/YYYY. The source is a date cube with format dates dd/mm/yyyy but when we doing a dataflow to rolap cube, the value can't save because Board try to extract Date Cube with format…
-
Sharepoint
Dear All, I would like load a cube using the informations contained in Sharepoint. I looked for a specific odbc for Sharepoint but without result, any idea? I could extract from Sharepoint to Excel or txt and than uploading in Board, but I would prefer a more direct solution. Thank you in advance for your help. marco
-
Merge Cubes
Hi all, I have two cubes with the same data in, but for different date ranges. I'm trying to merge the two cubes together in a procedure but seem to only ever get the values from the second cube. I've tried a=b and a=a+b. Any ideas?
-
Menu Bar Bag in Web (Board v10.1.2)
Hi Boardville, I am facing a bug on my menu bar when I view it in the web. I had a menu bar in place, but needed to add additional screens and change the order of the numbers. The adjustments works fine in the client: As you can see I have the screen numbers 1, 2, 3, 4, 5, 6. However in the web the menu in the same capsule…
-
Questions about MIGRATION BOARD10.5 to BOARD11
Hello Community, I need some advice before I upgrade. The conversion of the databases has to be done manually, at least in parts. This is described in the release notes. Extract from the RELASE Notes Database Migration The following activities must be performed to migrate a database to BOARD 11: Before upgrading to 11,…
-
Board impact on fine dining
Anyone using board in the fine dining restaurant cluster please.
-
Board 10.3 - functions Subscribe and Send-to?
Hi Looking at roadmap presented in Baveno it was expected such functions within 10.3. release: Subscribe: self -service function allowing to schedule the delivery to in your email of a capsule screen or presentation in PDF or XLS format. Send-to: delivers on a scheduled basis via email a Board Presentation to a list of…
-
BLOCK FORMAT @ drill down
Is it possible to format figures in Drill Downs? We do have a Drill Down with %-values and it would be easier to read the values with having a %-sign after the value. Thank you!
-
Can the B10.5.x Win Client and the B10.5.x Web run simultaneously?
Can the B10.5.x Win Client and the B10.5.x Web run simultaneously?
-
Has
Has anyone encountered this error on the Web Client: An error occurred (cod_ref: 1569346964571)? If so, what is the cause and how do I fix it? Thanks
-
How do I toggle the Presentation feature back on?
The Presentation menu does not appear in our development system but is available in Production. Have checked the documentation and can not find any options to toggle it on and off. I suspect I may have toggled it off in a earlier version but now can not work out how to toggle it back on. Board menu in development Board…
-
Board 11: Custom Time Entities & Relationship
Hi all, I am trying BOARD 11. I have a problem entering semester data via SQL DATA READER. My data does not enter the Time Entities. * My Semester time entity * Time Range Entities * My SQL Data Reader * Preview query * Result valid record 1827 * But, my semester entity is still empty. Ganjil is my dummy data so that…
-
Screen point of view bar
Hi All, I'm new to Board and moving first steps in developing screens/report. Is it possible to create a screen with a bar which works as a "Point of view" selection? I'm trying to better explain: When the user selects a screen, before reading and calcuating data I Want the user to select filters for Scenario-Company-Year…
-
There is anyway to hide and display the cubes in the dataview on the screen based on selection
i want to know is there any method to show only particular cubes in the dataview layout for few selection and display all the cubes in the layout for rest of the selection, that too in a single screen.
-
Board 11.1: How to use check box in block appearence in a dataview?
The checkbox wasn't working on board 11 or am I using it improperly? Found answer the cubes were not syncronous, my mistake.
-
Down Totals and disappearing dataview
Has anyone out there experienced the issue shown below (in 10.5.0) or able to explain what might be causing it? I'm displaying a single mapping cube, with data entry enabled, and axes set as below With DownTotals checked it shows fine Turn off 'Down Totals' as they're not needed/wanted with a mapping cube. ..and then…
-
Disable Data Entry on Grand Totals
Hi Boardville, quick question, couldn't find the answer in the search. How do I disable data entry on the Grand Totals? Best Mathias
-
when a user gets logged into the capsule and close it and immediately second user connects to the sa
both users connect to the same capsule with different credentials but with a single client, both log in to the application one after the other.
-
Dataview Drill down no value / show all
Hello together I have a dataview with 4 cubes and 1 of the cubes is a budget cube which has just some Basic entities. If I show the new data on a high level everthing looks fine: But if I drill down for example on the age (it is a entity that the budgeting Cube doesnt know) the result looks like this: The grey marked rows…
-
How can I compare Cube versions which don't align?
I have a large cube (~23mb), which due to it's size and use we have set up 7 versions. I have an issue where Aligning is not actually aligning call versions. Version 1 is ending up slightly different to Versions 2-7. I'm trying to compare V1 and V2 to hopefully work out where the issue is. The problem I have is that the…