-
10.6 vs 11.2 dataflow with different behavior
I create a dataflow that works fine in 10.6 and has different behavior in 11.2. The dataflow layout has a cube called Cubo1 type Integer, an entity called Seleccion1 which has 2 members and a target text cube called dummy2. with no selections, I expect at the end of the dataflow that cube dummy2 should have value "2". That…
-
How to Adjust Position (Fine Tuning with Arrow Keys) of Object in a screen in Board 10.6 Web Versio
Hello everyone, We just move Board to 10.6 Web Version. In the Board Client, we can adjust position (Fine Tuning with Arrow Keys) of Object in a screen, but it seems we cannot do any fine tuning on the web anymore, we only can use mouse to move the object, which is very hard to adjust the position of Objects with very…
-
Assigning new codes to existing Entity members
Board 10.x question: We have about 200 existing entity members across three Entities which require new codes due to changes in the source system. E.g. 12 Apples with code 12 will now have a code of 0010 - the member/description is the same but just has a new code. The existing members are referenced by Procedure…
-
line break in the web dataview
in the board windows client a line break is made in the dataview. Unfortunately not in the web client, how can you activate this?
-
NEXEL writeback not working
MAXIMUM URGENCY Hi everyone, I have a problem concerning the Nexel writeback. As you can see from the picture attached (which is the Nexel layout shown in the debugger), the procedure enters the writeback with the proper selection, therefore the layout is not too big. It writes correctly on the target cube but then, after…
-
Prior Year Total
I can current YTD (yearly cumulative value) and prior YTD (yearly cumulative value with prior year selected), but how do I get the full Prior Year total? I don't want a moving total. Eg; If the selected month is March 2020, I want the January 2019-December 2019 total.
-
Comparison day week from one year to another.
Hi ! I want to compare the date figures from one year to another year. For example, compared January 1, 2019 to January 1, 2020. This part works. However, I have a custom entity with the days of the week: Monday, Tuesday, ... and I want to compare Wednesday January 1, 2020 to Wednesday January 2, 2019. My problem is that…
-
Board 10.6 Web Service Error
Hi all, I installed Board 10.6 on a brand new machine (MS Server 2012), and configure the Web service as followed the instruction in https://community.board.com/viewdocument/how-to-setup-microsoft-iis-with-boa?CommunityKey=fce3410b-1520-47cb-bd8c-6cdd5a5b5ad9&tab=librarydocuments I can access Board via Web on the localhost…
-
Revenue and expenses positive
Hello everyone, I had this question a few times now and I have always tried to talk clients out of it, but I thought I ask the community in case someone came up with a solution. Is it possible to have positive values for revenue and expenses and still have subtotals and grand totals that make sense? BOARD just aggregates…
-
Procedure to extract list of users
Hi, I have many databases with special security profile depends on users entities. Today every time I create a new User I have to create the entity and use it in different cubes and others. If I can extract the user list in a procedure I can fix everything I need, but I don't find in the procedure list the option to…
-
Selection in Screen after Reload of Entities
Dear all, we wanted to clean up our database from entities, that are not needed. I decided to do it from scratch. Therefore we are extracting the cubes, clear the entities, reload the entities and reload the cubes. Looking at some reports I noticed, that the selection in the capsule/screen has changed (see screenshot). Is…
-
How Do You Display Percentages on Pie Chart
On a Pie Chart is it possible to display the percentages on each slice of the chart.
-
Set Data Entry to All Row
Hello, I want to set a date in data entry. I just want entry only once, and the another row automatically filled based on entry the first data. Can BOARD possible do that? and How? Thanks, Best Regards
-
Data Reader Warning
Hi everyone, Does anyone know about this message? This is the message when I run the Data Reader. Warning : RBT1826 The value [0] found on column 34 is not valid and cannot be loaded into the cube?? From what I've seen, there's nothing wrong with the data. Thanks.
-
Query Data Reader (SET DATE)
Hello Everyone, I have a case. Just want to read a Data Reader from Excel data. So i used the ODBC Excel Driver. I used manual query, because want to set a entity with a current date (format 'yyyyMM'). So i used (like picture below) this query like SQL Query, but obtain an error. Any solution for this case? or what…
-
Seconday Y Axis - Web Client
I've been working on the web client and I have been unable to set which Cube uses the seconday Y Axis. Cheers ------------------------------ Board Ver 10.5 Jason Ferguson Australia ------------------------------
-
Migrating cubes to BOARD 11.2
Hi, I have been unsuccessful in being able to migrate my cubes from a BOARD 10.5.1 database to BOARD 11.2. The database conversion was successful, but the cube reload fails once it hits a cube with multiple versions. How do I complete the migration of cube data to the new database? Thanks, Stephen
-
Clustering and B11
We have a BOARD customer that need to use BOARD in very remote location(s) via satellite connections. We've done our best to build a solution to allow for the expected latency (tested via latency simulation), but now they appear to be having bandwidth issues at the first/test site. We're wondering if Clustering is an…
-
Performance of a Progress JDBC Driver in a C2P architecture
Hi, question to community: I have a Progress JDBC connector installed on Cloud, and I can't optimize data transfer with Progress options. I have a Board Cloud Application connected to a Oracle On premise DB. My performance now are: ~30k record at second with optimization of oracle table index and the initial query take…
-
New Forum
Hi Boarder! That looks really nice! I'm curious how this community-site will develop! Wish you all good luck and especially health! Come well through this difficult time! ------------------------------ Dirk Magerkord Leiter Controlling - Prokurist Dachdecker-Einkauf Ost EG Germany ------------------------------
-
Missing relationship log
Dear all, does BOARD have a log on the missing relationship? I am looking to allow to the user to check if normalisation occurs and/or if missing relationship happens on the capsule.
-
creating action in procedure is slow
Hi I need someone' help to solve a problem. It cost 10 minutes to creat an action in Capsule's procedure, it was very slow,but it is very fast to open a datavflow in Capsule's procedure.If you know the reason,could you tell me the reason?
-
Column algorithm
Hi, I want to ask how many function that can be use in column algorithm? I have already downloaded below functions from board . --->BOARD - Layout Algorithm Syntax Are there any more functions that can be used in column algorithm? e.g. like date compare function ? string compare function? thank you Hanyue
-
Why it costs so much time when open a dataview?
The dataview that I created is not that complicated, but it cost much time to open. What should I do to adjust it ?
-
Migrating to new Server
Hi all Looking to migrate from our 2008 server to a 2016 server. Currently on board 10 but have downloaded the latest board 11.2 server setup and 11.2 web. Is there a guide anywhere with the correct process to migrate from one server to a new server? Database backup, and all the files etc ? Cheers
-
BOARD Chart Object
Hi, we want to implement a central dashboard (SIOP Graph) for our logisitics guys in the plants. The central chart is a combination of a few kpis, which build the different bars. Another aspects are the vertical lines, which show thresholds. My first question is: is it possible to create a chart like the one shown…
-
Dataview Axes Vertical Alignment Shows All Empty Rows
Hi Community, I have encountered a peculiar behaviour of Dataview (align Vertically) and would love to get some feedback from any Board experts here. I have a Dataview which I changed Align from Horizontally to Vertically, with Show All unchecked on both By Row and By Column. The Dataview (when aligned Horizontally), will…
-
Rule only partially working
I have a rule that is only partially working. The rule itself contains a great many calculations in an entity that has approximately 600 members to emulate an existing calculation. Simply put, some of the calculations in the rule are calculating correctly, and some are not (it matters not whether the rule for the line item…
-
Broadcasting in Admin Console
Hey, we are using 10.6 (Revision 0.1.32761) and I wanted to try out the Broadcasting functionality. Everything is configured so far and we are able to use the "Send To" functionality within the presentation's panel. But there is no "Broadcasting" tile in the administration panel. Did I miss something? After setting up the…
-
bar chart markers
Hi, I have a problem with the rotation angle of the bar chart markers. I'm using the WinClient Version 10.6.0.2. I'm able to set the rotation angle within the WinClient, but it will not show in the live view of the screen. The rotation for the primary x axis is showing in the live view. For details see my screenshot. Can…