-
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.…
-
How to use the API to exchange data between Board databases ?
Hi all, I have been wondering recently, with the new Board API functions, is it possibe to use it to read data from a Board database to another, or within the same database (to manipulate data through mapping and / or ETL functions that would not be possible through dataflows) ? If yes, how would you do that ? Thanks,…
-
Update SQL DB
I know that I can create an infocube using RDB. My ODBC connect is set with user who has read and write rights. Can I update my SQL Table with Entity data or MDB inforcube data using the RDB infocube? How do I accomplish this task? Thank you for your help. Tuyet-Lan Faber
-
Dataflow using rule with datapicker issue
Hello, I am having an issue with a dataflow where I apply a rule to the source cube in order to populate some metrics. The rule uses data picker to populate data for the entity. After running the dataflow, the target cube is empty, however, the source cube displays the correct data when the rule is applied. * Source cube…
-
Auto refresh of a screen
Hello, We would like to use ROLAP (RDB) Cubes to show nearly real time data. Is there any possibility to auto update a screen or an dataview object in a time interval. Board Web. 10.7. Kind regards, Marco Oerder ------------------------------ Marco Oerder BI-Reporting Optibelt GmbH Germany ------------------------------
-
Sorting on Nexel column
I just tried to sort the content of a dataview by using a column that is based on a pretty simple Nexel calculation (single rule), but apparently sorting does not work on Nexel columns. Data type is numeric. If I click on the header of the column, sorting is working fine, but I would like to have it automatically, on open,…
-
Pager in ATO Enabled Panel
Is it still possible to have an ATO enabled panel with a Pager in 10.6+ web? In WinClient we drag the panel onto the screen, enable ATO on it, then drag a Pager into the panel. When I do that in 10.6 web I get… "you cannot drag a Pager as a child of an ATO" I'm hoping there's just a different process to achieve it, and…
-
Showing 3 different dates in a report
Dear, One of my clients would like to have a supply chain report wher in 3 dates are available. Creation date, shipment date and requested confirmed date. So creation date of the order and shipmentdates and requested dates of the order. I don't know what is the best practice is creating something like this. Do someone has…
-
Filling MXC cube fails
I created a MXC cube to be able to find out how many parts a supplier delivers. When I fill the cube with the data reader the process fails and I don't have a clue why. Any ideas? ------------------------------ Andreas Jeske Anwendungsentwickler Nolte Küchen GmbH & Co. KG Germany ------------------------------
-
psexec
dear all, someone used PSEXEC in Server-Side Procedure? We tried to use but doesn't work and no logs wrote. We need to launch a BAT to another server in the same network. This .bat works if we launch by task scheduler. Thank you ------------------------------ Mirco Righetti Responsabile Business Intelligence CALZEDONIA SPA…
-
Login Web Issue
I have issue about Login Page in Web Mode. Every login, Screen Login redirect to Logout screen automatically. Can you please help resolve. I have not saved the session ID in the bookmarks and just using URL. ------------------------------ Harsha v Financial Systems Lead Technicolor Limited India…
-
pattern based allocation - how it works?
Hello all, I'm searching for a description (Doku, Video...) for the function "pattern based allocation". How must it be configured? I hope someone can give me some help. Thanks in advanced. ------------------------------ Stefan Batalia Board Administrator Arntz Optibelt Group Germany ------------------------------
-
Excel Addin BSAVE Function
Hello, I am looking for help on the new BSAVE function (Board 10.6) I didn't find recent documentation about Excel Office Addin. Thanks, Karel K.
-
Update User "Personal Info"
Hello, Is there any possibility to update the "personal info" of an user by upload? Kind regards, Marco Oerder ------------------------------ Marco Oerder BI-Reporting Optibelt GmbH Germany ------------------------------
-
LOG MANAGEMENT AND ANALYSIS
Hello all, we are using Board Version V10.1.4 with Windows Clients. We will update to a newer version, but before we do that, we will look for old not needed reports. I know from the pass that we had a tool (Capsule) named "Log Management and Analysis". Have someone a documentation how to use this? Thanks in advanced.…
