-
Effective approach to copy data from one version to another
When we need to copy data from one version to another, we usually adopt the temp cube approach. Copy data into temp cube without the version entity and then write it to the original cube into another version. This could be quite a bit of a task if you are required to copy data for all models, there could be a large number…
-
Block hidden if
Hello, I have a layout with 3 blocks. All have data entry available. I would like to display the third block only if the user has selected a specific entity. Let's say my entity is the year, I would like to display the block "c" only if the user has selected the year 2022. If the year is not 2022 i would like to see only…
-
Month entity without year
Hi, I'm using a dataview for sales analysis. On the rows I have the year entity. I need to put the month on the columns, to get 12 columns of data (1 for each month). If I use the Month entity I get one column for each month of each year. My Year entity has 5 years, so I get 60 columns. Can the month name be extracted from…
-
[IFRS16 APP BLA] Cube Corruption
Hi, We recently had a problem with a procedure because some cubes were corrupted, are there any best practices to follow for to prevent this problem in the futute? The version of the BLA database is 12.1. Thank you in advance for any response, Francesco. ------------------------------ Francesco Tufaro Consultant TECHEDGE…
-
Hide screen in menu
Hello, I'm starting with the new board (V12.2) and I'm struggling a bit to add a menu. With the previous version (V10.7) I was able to select manually the screens to add in the menu. Unless if I'm wrong, it seems with the new version we cannot exclude some screens ! (it's all or nothing) I have some screens that i want to…
-
Data View with data entry and pre-set values
Hi guys, I have come across this when trying to create a new screen for a revenue centre. What I want to create is a similar function to Vlookup in Excel (see below). Client is existing entity in Board. Class is a data entry cube. And i'd like to have revenue to look at another mapping table. When user entered class as…
-
Corporate Identity Designer in BOARD 12.2
Dear community, We are going to updated from BOARD 10.3 to BOARD 12.3. Currently, we are missing the Corporate Identity Designer in BOARD 12.2 Has anyone seen this feature in BOARD 12.3? Regards, Jörn ------------------------------ Jörn Constabel Controller Braunschweiger Flammenfilter GmbH Germany…
-
BOARD 12.3 - data entry via PASTE has 'changed'
Is there anyone else using 12.3 that has discovered you can no longer 'paste' values into a dataview and have them go across the row? when you paste into a dataview, regardless of what cells you select BOARD now pastes them down the column. Yesterday in 12.2 they went across the row... today after we've upgraded to 12.3…
-
Error: The client application is not known or is not authorized. (B12.2 Rev 0.0.67608)
Hello When I want to log on to BOARD 12 via a fully qualified URL, the message The client application is not known or is not authorized appears. With a simple URL it works. Restarting the engine did not bring any success. What do I have to change in the BOARD server settings? ------------------------------ Matthias Alles…
-
Diagnostic log
Dear all, we are in progress to updated from 10.3 to 12.3 As written in the release notes, a new logging is available in BOARD 12. The diagnostic log. The only documentation I found is this: Other enhancements Does anyone know how to configure the verbosity level of the logging? Regards, Jörn ------------------------------…
-
Excel Add in - Setselectionwithrefersh
Hi i have tried "setselectionwithrefresh", and successfully created multiple layouts with auto refresh in one worksheet. however, it seems ""setselectionwithrefresh" apply the selection to all worksheets, how to make the setselectionwithrefresh only working for one worksheet and only, as i need to create different…
-
Workflow
Is there any way to create workflows in Board? For example a user A wants to get authorization signature on a report from user B and after user B authorizes it , the same report has to be sent for authorization from user C. ------------------------------ Kumar Harsh Analyst EY GLOBAL DELIVERY SERVICES INDIA LLP India…
-
Dataflow Aggregation not Working
I have two entity trees: A -> B -> C and, P -> Q -> R I have a cube dimensioned: (Month, C, Q), and I want to populate another cube aggregated by R: (Month, C, R) When I build the layout (Month, C, R) in a dataview it shows the data the way i need it do, but when I run a dataflow to populate a cube with the same layout, it…
-
Board 10.6 IIS Kerberos settings login
Hello, we have searched in the KB library and in some post, but we can't find the correct settings to setup the Windows authentication to Board Web via Web Browser . Actually we have setup Board 10.6 Server with the IIS active service and Board client also works great with Windows and Board defined users. Unfortunately…
-
Best practice to add a dimension to existing cubes (Board 12)
Hi, I need to add a new dimension to some existing cubes. These cubes have a dimension related to delivery customers and the new dimension is relative to invoiced customers. Is there a best practice for this scenario? I followed this steps: - Entities creation (Invoiced customer, city, category, ...). - Relationship…
-
BOARD 10 Metadata Export - BOARD 12 Impact Analysis
Hi community, we are now new in BOARD 12. Is there any way to extract the Metadata in BOARD 12 like the Export of Metadata Export in BOARD 10. With the Impact Analysis you can analyse where there is a impact, but it is not recusive. With the old way i could collect every Field in any way and go trouth it in a recusive…
-
Winter Release 21
Hello everyone, has anyone migrated (from 12.1) to the new winter release (12.2) yet? I am very curious about your experiences here... Best regards, ------------------------------ Dominik ------------------------------
-
Allow formatting of reports at data view level rather than creating entities
Hi All, I have submitted this idea in the Idea lab and would request you all vote for it if you consider it worthy. In my opinion, there should be a way to manage the formatting of how we would like to display or format our data on the data view, at the data view level rather than creating multiple entities at the data…
-
Temporary cubes
Hello everyone, I have very high expectation for temporary cubes and I make a lot of use of them for dataflows. Based on the documentation Board 11 Release NotesProcedure Temporary Cubes It is now possible to define within a Procedure one or more temporary cubes that are created and used only locally within the scope of…
-
Grand Totals on Vertical Block Alignments?
Hi Everyone, I have this Data View with a Vertical Block Alignment, with Location Group on the columns and Categories on the Rows, with the Data for each Category Thank you! Is there a way to get a Total of the Categories for each Data Cube? Ideally, there would be a "Grand Total" After "Activity/Toy" with the same six…
-
transposer
dear all, has anyone used the TRANSPOSER in order to separate board environment in development and production? Regards
-
Error Message at Login
Dear, Our users has been seeing this notice when logging in. (see picture) I restarted the server several times but it is still not helping. Any ideas on how we can fix this? Thank you in advance for the support ------------------------------ Moses Emuze Business Intelligence Consultant Handelmaatschappij A. Smit en Zoon…
-
Microsoft API - Dynamics
Hello, Where would be the best resources on how to connect to Microsoft Dynamics? ------------------------------ Patrick Murphy Consultant KPMG Ireland Ireland ------------------------------
-
Can't open Capsule
The capsule can not open to work and lost to screens. How can I fix The capsule?
-
Apply Rule to Algorithm Block
How can apply a rule to an algorithm block? I need the rule to calculated on cell values after the algorithm is applied, instead of the rule applying the underlying cubes, then pulling across to the algorithm block. ------------------------------ Mark Developer Australia ------------------------------
-
Dataflow with open sparsity not working
I have found a solution! hi, I have a problem with "open sparsity". I have values in a cube by customer, item and sales organization (all as sparsity) and now I want to change the values from one sales organization to another by procedure. To do this, I first select the organization I want to take the values from and write…
-
Time functions in data flow - BOARD 11
Hello everyone, Does anyone else have issues with time functions in data flows with BOARD 11? I am using "Yearly Moving Total" (often together with a large cycle for balance sheet values) or "Yearly Cumulated Value" quite often and none of those seem to give me the right result anymore. It looks like it is completely…
-
REST API Connection
Hello all, I will setup a REST API Connection with Board 12. I'm searching for a documentation how to configure that? Can someone help me? ------------------------------ Stefan Batalia Board Administrator Arntz Optibelt Group Germany ------------------------------
-
Drill Through Export
Hi all, is there a maximum number of rows I can export in the Drill Through? I always get the following error message. Is it possible to change the setting so that multiple rows can be exported? Thanks, Maxi ------------------------------ Maximilian Petru Solution Consultant SPL Tele GmbH & Co KG Austria…
-
Write date (from interactive selection) in a text cube.
Hi to all, In a procedure there is an interactive selection on entity Day. This selected day has to be saved in a cube. I try to do this but I'm not be enable to write date in a cube. This is the step in the procedure The cube WIP-ValueDay1 has value 1 for each day/project The dataflow write value 1 instead of the date.…
