-
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
-
Data Picker -
Hello all, today i started to familiarize myself with the topic nexel and data picker. Now I tried to enrich values from one cube with a column from another cube. Here I come also fast to a result, which I cannot explain to myself however. The dimension of the value seems to overflow. Can anyone give me a hint which…
-
Is dynamic entity selection slow?
Hi all, so recently we were trying to create some kind of 'save my current selection' button. You could also call it report variants, or saved queries,... One of the ideas was to filter all the entities dynamically. See Dynamic Select. Now the thing we were working on, didn't really work the way we intended, but we kept…
-
How to save the current selection (to file/db/cube/...)?
Hello, I'd like to save the user's current selection via a procedure (click on button to save), in order to be able to restore them later (click on button to retrieve and set). This way user's would have their own saved queries (I intend to limit the amount to 5 and have 5 Buttons). What I've tried doing is storing the…
-
Rolling Up Time Stamps into Hours
Greetings! My problem is this, I need to be able to track the number of records being entered into our system by Day and Hours. I currently am loading a cube from SQL that contains a Date/Time Stamp field. I am cubing off the Date by Day but need a way to delimit the Time Stamp and find a way to roll up these times into…
-
Total By on 1 dimension cube
Hello, My use case is as follow : In one screen some users mark members of a dimension using a cube with checkbox. In another screen, different users should see the percentile of member marked that represent the selection they made. Therefor, in one block I need to do a "Total By" to count how many member are marked…
-
Apply Master Layout Selection to Drill to Screen
Hi, I have an application with two(2) screens(lets say Screen1 and Screen2). On Screen1 are two(2) dataviews(lets say Dataview1 and Dataview2). Dataview1 has Master Layout enabled and Dataview2 has a drill to Screen2 configured. My problem is when I do a master selection in Dataview1 and then a drill to Screen2 from…