-
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
-
How to create a report with several cubes grouped in lines?
Hi, In Excel I have a report that looks like this: What would be needed in board in order to create a similar structure, where the different cubes are over each other (by rows) instead of side by side (by colums)? BR, Ray
-
Change web interface
Hi, i was trying to change the HTML5 interface, trying to customize the ribbon bar and web landing page login. How can i change those? I have been mentioned these can be configured and changed but was wondering how Thanks in advance,
-
Why aren't my percentages correct for the Total columns/rows?
Hi I'm a fairly new user of Board, so this might be something obvious - I've been building financial reports, but with my percentage calculations, through using rules, the percentages are correct on the data columns, but incorrect on both the total columns/rows. Values are all divided by 1000 to get $'000 for my financial…
-
Refer-to + rules?
Hi all, is it possible to use the refer-to in the layout and have the cube take the value of the rule that is used in combination? Say I have a cube a, with a rule "measures" (in functions) and also a "refer-to" to a value that is computed in the rule. In my case the result is empty. How'd you do that? BR, Ray