-
Dates format EU vs US
Hi Community our server is in Italy, with local settings dates in reports are viewed in the format dd/mm/yyyy Some US users would like to view dates in the format mm/dd/yyyy Is it possible to do something locally, without affecting same reporting when used by EU users? thanks
-
Month selection based on a Start Date and End Date
In order to create a Project (i.e. promotion) management function (which allows end users to add and edit promotions in Board), I've created two Date type cubes for a project Start Date and End Date respectively, which contain only one dimension - Project ID. The requirement is after both dates are entered by users, the…
-
How to sort by a value for a axes combination in DataView
As shown in the screenshot below, we have a Sales cube and Budget cube, which have the same dimensions - Item, Area, Month, UoM. We tried to calculate the Severity (i.e. bias) and present the data in a flatten dataview showing Severity in descending order so we can find the most problematic Item/Area combinations as shown…
-
Alignment and hierarchies in Board 11
Hi all, as in Board 11 the engine is taking care of the versioning I was wondering about the following scenario: We have an entity customer and a second called customer group. They are connected in a hierarchy. Unfortunately customers can change customer group. In that case we reload that part of the tree. Now if a cube…
-
Data readers moved to Unassigned Items
Hi community In a database I found all data readers moved to a unique group "unassigned items" All is running regularly, entities and cubes are still in their groups No strange things in reports or processes. Why this behaviour? How can I fix it? Are there consequences related to it? Hope someone can help thanks a lot!
-
Community edition of Board available ?
I have been working with EPM products in past and would like to try out BOARD and its EPM capabilities. Is there any community edition version of the product available to download and try out? What are other options to get started with some hands-on on the product ?
-
User list as entity members
Hello community! Is there a way to automate extracting the list of users from the system/security tab in order to easily data-read them and add them to a User entity (I would like to create a log cube by date and user to record the connexions to the capsule). Thank you for your help! Paul
-
Calculate projected inventory
Hello Board Community, I would like to calculate projected stocks with the following formula : Stocks = Previous month stocks + current month Supply - current month Sales. I have 3 cubes : Sales, Supply and Stocks. All cubes have 3 entities : Month, Part number and Market. Sales and Supply have values for 2019 (Actual…
-
make a new line in dataview
Hello everyone, I have a dataview like this (see below): Is it possible to have a new line below TH-611AL with the same name? I want my dataview like this table: Thank you.
-
Board 11 capsule images
Hi all, I guess that Board 11 will still support capsule images. If not, it's just something to plan for. My question is: do the images get loaded each time they are requested or are they cached by the browser? BR, Ray
-
Possible bug?
Hi, As a power user I can modify a process flow and run it, even if I don't have the rights to save the changes. 1) select a procedure 2) modify any steps (adding/removing also possible) 3) click run. Board will ask if you're sure you want to save the procedure 4) click yes. An error message "Cannot save procedure" will…
-
BOARD11: Select based on cube (Screen)
Hi everybody, I have a question regarding to the dynamic selection feature in BOARD 11. I'm trying to set a dynamic selection based on a cube in a screen and inside the selection It allows me to enable it but not to select the cube (I attach the images). Does anyone have the same issue or can help me? I know that it allows…
-
(FIXED) Web Capsule Tiles - Issue When Changing Capsule databases
ISSUE: When changing the database from the developer version to production, it is vital that the Web Capsule Tiles are manually updated too. Failure to do so will result in the capsule failing to open in web. Having upgraded to BOARD 10.5, I can confirm that this issue is still current. BACKGROUND: I develop in several…
-
Data flow no more working
Hi community I have a data flow using join that regularly works with version 10.1.2 and is not working with 10.3.0 (last release) See the picture
-
Filter / select in Data Flow
Hello, is it possible, to apply a filter or a select on a data flow? The source cube has different entities like customer, productgroup, product. Now i want to start a dataflow with a procedure to select or filter one productgroup (fix) and copy the values of this productgroup to the target cube. kindly regards Uwe
-
Alert on calculated Label seems not to work in BOARD 10.5 Web
I created a label which I used to show a trend arrow with this formula: if(a>0,"?", if(a<0,"?","→")) where "a" is a simple numeric cube, which is also part of the label layout. The result type of the formula is set to text. The formula is working correctly and the right arrow is displayed. If I set an alert on the formula,…
-
Data flow: How to distribute a value on different entities
Hi everyone, I have to distribute one value per customer and month on a cube per customer, month, item and agent, based on the turnover cube, also with customer, month, item and agent. On these 2 last cubes, "customer", "article" and "agent" are in sparsity. I made a dataflow with the following steps: a: value per customer…
-
Rolling Forecast
Hello, i want to build up a rolling Forecast modell for monthly data entry and adjustments. I have 2 Cubes. One with actuals and one with forecast (incl. Version). Now i want to select a time-frame for the past month (like 01-03) and a Forecast-Version (like April) an fill the Forecast-Cube with actuals from the previous…
-
Cumulated values on selection
Hello, I have a chart where I show actuals per week (primary axis) and cumulated values (secondary axis) of milestone progress. The cumulated values are YMT with a cycle of 999. As you can see in the graph the cumulated values are in week 02-2019 about 1,200. Is it possible to start the cumulation of the values in the…
-
(FIXED) 10.5 Functions: WEB Object Copy and Paste
A new BOARD release is a very exciting time. Scrambling to read the release notes, diligently comparing version functions from one to another and then writing up the upgrade strategy utilizing the best 'agile' means to ensure the quickest and most efficient pathway to the update and release of all current models. Ah, the…
-
Summarized Forecast Rollup from different screen totals
I have multiple screens for forecasting based on different types of revenue. Because these sections belong to different areas of our company, the forecasts are data entry enabled. We don't just use a growth % assumption and calculate. I would like to take the totals from each of these screens and roll them up into a…
-
Use of @user / @username to segregate data
We have a capsule which does some kind-of complicated processing such as writing to a text file from a dataflow and reading it back in to some work cubes and then displaying a screen based on the work cubes. If more than one user is using the capsule it works alright. When user A loads the work cubes and displays results…
-
data entry in a dataview with filters applied
Hi all, I have a cube which contains both future forecast and past forecast (forecast created previously). There are three dimensions for the cube - Product, Market and Month The requirement I got is to show both past forecast and future forecast in a chart, but only show the future forecast in a dataview which allows…
-
1 Dataview serving 2 other DataViews
Hello, What is the best approach to do the following: I have 1 main DataView. The user selects a row in this DataView to load more details in 2 other DataViews (each with its own specific details) on the same screen. In other words, have the Drill-Down row functionality but then in a separate DataView on the same screen.…
-
maximum number of axes
I am trying to build a report using a data viewer, however firstly I had to put entities in as axes so that they can be flattened out rather than having them in the data block, which just returned the total count in that entity. However I now find that if I have more than 2 entities in the axes the screen does not display,…
-
[bug] Screen corruption after cube deletion
Hi, I have a screen with dynamic selection based on cube. Unfortunately, I forgot and I delete the cube. Now the screen is unusable. Every layout in the screen show an error - Database is modified by another user. My suggestion is that the screen should ignore the deleted cube. Hope other users will not encounter this…
-
Export to Excel error
Anyone in the community had this error pop up before when extracting to Excel?
-
Dataview converts text to figures format when using Vertical Axis
(BOARD Version: 10.1.4) We are all aware of the restrictions when displaying Data-views vertically; no drill downs, formatting issues, etc. Recently, I discovered another one BOARD will automatically coerce entity members comprising of a string of figures into a numeric format with thousand separator and right justified.…
-
excel column limit
hi community, i have a datreader from excel file, i wanto to know if there is a column limit to import data from excel. Regards Andrea
-
Installation details
Our organisation has just signed up as a partner. I have completed the initial courses and am looking to move onto the exercises. My question is what version of Board should i be downloading and installing? Regards, Andrew