-
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…
-
Error after 10.3 autoupgrade
Hello Running the client autoupgrade in some PC's apperas a warning message that only says "Access denied" (see picture) but just pushing OK it regularly connects and works. Has anyone experienced this? What could be the reason?
-
Merge Capsules
Hi, I am working on an application in which the application is divided into multiple modules. Each module have its capsule but one database. now the requirement is to merge all the capsule into a single capsule. How to do that ?? Any help or idea.. Thanks
-
Client Web - Create PDF Report not working
Hi Guys, I have a Board application running on Board 10.3 for which I don't manage to create a PDF report when using the Web client. When I click the create report button (either in the top-right corner menu or directly on a screen object), the loading circle displays on the middle of the screen and nothing else happens…
-
Export DataView - keep column width
Is there a way to maintain blocks width in a DataView export, with formulas, to Excel?
-
Add entity - Limit Relationship entities
Hello, in our planning module users can add new projects with ATO where they can also set the relationships. For example, they can choose to which segment the project belongs to. As you can see in the screenshot there are four segments in our database. Is it possible to enable users only to choose segment 1 or 2? Segment 3…
-
DateHour view
Hi community I fed up a date cube with a string like this (including the hour) Figures are correctly stored in the database but in the data view I'm able to see the day only If I export such layout in a procedure action I see it...Is there a way to see the hour in the data view also? thanks!
-
Dataview block with Numbers & Text
Hi Guys, I've a formatting issue with a dataview for a accounting report. In one block, I need to have a percentage resulting from a calculation of 2 other blocks when a condition is fulfilled. Otherwise I need "N/A" to be displayed. So far, I did the follow in my dataview : - created 1 algo block for the percentage…
-
Usage Statistics Dashboard
Hi Guys I would like to create a Board dashboard that displays usage statistics for Board dashboards. At a high level, I would like to know who is using which reports and when, but I would also like to gather figures that can inform future report and dashboard development. For example, I would like to be able to tell how…
-
dataflow hbmp+ or CellBased+
Hello, I create a dataflow to divide the planed article sales on the customers. First cube (ZW2_Umsatz) has the dimensions month and Produktmodell (article). Second cube (percent per customer) has only dimension customer . If I calculate this two cubes to a new target cube (ZW3_Umsatz) with the dimension month,…
-
Erroneous dataflow from text to single type
Dear all, While doing some tests, I came across a problem with a dataflow from text to single type in BOARD 10.3 (Didn't try in older versions). Let me explain the whole business case. 1) I pull in a "creation date" column from an Excel file and apply an ETL function on it during the data reader. The ETL function is…
-
how to add a new screen
This might seem super basic but how to I add a new screen to a capsule in Board? A consultant set-up the cubes and I attended the training (over a year ago) so I'm very rusty. Once I have a blank screen I think I'll be ok to start using the cubes but I just can't remember how to get there and I also can't find anything in…
-
Analytical functions > more details regarding "average"
Hi, I would like to use one of the availableanalytical functions : average According to the help, Average: it returns the average value of the series (Total/Time Length); Can anyone give more details on how the average calculation works ? * how happens the aggregations ? * Does the function apply after all aggregations and…
-
Date-time to be shown in label with a different time-zone. Ideas?
Hi everybody, I would like to show in a label the current date (@date) and the current time minus 1 hour. That's why Board server is running in italian time, I would like to show in the label the UK-time. I've done it with a very complex nexel Is there someone with a smarter idea? Thank you, regards, Edoardo Tags: dates…
-
Dates shown in Browse and used in WHERE are offset by 1
Just wondering if anyone in the community has come across this issue before and found a robust/correct way of dealing with it. BROWSE doesn't match what is loaded into a CUBE. The Browse on a SQL query shown below lists several dates by employee. The Dataview below shows what is actually loaded into the relevant date…
-
select on higher level in hierarchy
Hello all, I have this dataview where the products are on the rows. There are a couple of columns that are higher level entities: Now there's always the possibility to select by the rows' axis in the context menu of the dataview. I would like to expand that feature, by means of procedures, and build a context menu like the…
-
Dataentry directly on DYNAWRITE
Dear all, does anyone knows if is possible to enable dataentry on a dynawrite with text cube? Thanks
-
How to Calculate a Day and Today?
Hi All, I want to calculate day and today, How Board handle this case?
-
Broadcasting & pager
Hi, I would like to use broadcasting to create a series of files (subdivided by a particular entity) each of which has inside it, a panel container with "n" objects (dataview, graphs). Obviously, there is a pager for this entity. There is also a dataview to which the broadcasting refers, always expressed for the same…
-
How to filter data with (not)exists?
Hi all, I'm trying to select customers that buy a certain product (sql equivalent of exists). And I want to display their total sales, not just those of that product. Similarly I want to search for customers that don't buy a certain product and display their sales. How'd you best achieve that in a dataview or for the whole…
-
How to align graph with 2 axes
Hello All, I have a graph with 2 axes, first axes for EBITDA and second axes % EBITDA vs revenue. The 2 zeros of the axes are not aligned as you can see in the attachment. Any suggestions? Thank you and best regards Marcel