-
moving total column
Hi All, I'm wondering if here would be a possibility to move the total column. I have a report like below: Material | Day1 | Day2 | Total and I need something like this: Material | Total | Day1 | Day2 Is it possible? Thanks! Regards, Lina ------------------------------ Ellina Mnikh Controller Germany…
-
"Last Selected Month" Values in a Column without using procedure
Hi everyone, I would like to create a Layout with a column that contains the data from the last month selected in the screen without using the procedure with step "apply selection to layout block" I tried to use the "Last Value" Option but in case that the data are null for the last selected month , I had the last non Zero…
-
eLearning Update: New Product Tutorials on B11
Make the most of your complimentary access to Board e-Learning until the end of 2020 Hello Boardville citizens, We have some very exciting and long-awaited news for you all: we are releasing new eLearning catalogue, entirely updated for Board 11 software version and featuring three courses: Data Modelling, Report Design,…
-
Mapping/ Join SQL and CSV Data
Hi all, I'm quite new in Board and would be happy to get an advice to my topic. I use ASCII Data Reader to get the inventory data from a csv. To get some additional information like material description I add a database table Material via SQL protocol. Both of them have a common column calling Material code. I would like…
-
4/4/5 reporting - Custom Time Entity set up
Hopefully there is someone in the community that has set up 4/4/5 reporting (rather than monthly) that can tell me if this worked for them. (I have a few open tickets with support on this DB which I'm not getting any replies to, so I'm not sure if it's a BOARD issue or it the DB has gone bad). I need to change a client's…
-
Keep labels dataviews together
Hello, See below picture. I made a chart wit above 2 labels and 1 dataview. I need to make 12 charts on 1 page. How can i keep the 2 labels and dataview together when i use copy paste ? Or do i need to use a container ? Is there an easier way ? ------------------------------ Carla Janssen Finance & Control Attero…
-
Copy screens across capsules in web client
Is it possible to copy screens across capsules in the 10.6 web client? This is possible in the Windows client but now that we are migrating to the new web bcps format I cannot find a way of doing this. I can see that you can copy objects with the copy and paste buttons but how do you select a whole screen (with selectors,…
-
How to add two dimensions by column without displaying row totalss
Hello! I have a cube with 2 dimensions : day, product. (relationship: day(N)-> month(1), product(N)->plant(1)) for example, I want to populate plant and month by column in my data view. Usually, if I populate 2 dimensions by column, there will be an error. -> "an error occurred" as picture 1. I could get a result only if I…
-
Mapping/ Join SQL and CSV Data
Hi all, I'm quite new in Board and would be happy to get an advice to my topic. I use ASCII Data Reader to get the inventory data from a csv. To get some additional information like material description I add a database table Material via SQL protocol. Both of them have a common column calling Material code. I would like…
-
Dynamic Column Layout
Hi Can we have a dynamic column Layout using Pager ? (The columns of the Layout should change depending on the Pager entity selected) Thanks, Vamsi. ------------------------------ Vamsi Krishna Associate Software Engineer SIMBUS TECHNOLOGIES PRIVATE LIMITED India ------------------------------
-
FYTD calculation error - Calendar issue or not?
Just wondering if anyone has come across this issue before? It is in a client's capsules running 10.5.1, and I've just moved it to the most recent 10.6 and it's there too.. I display a cube with a dimension 'by columns', and day by rows (or/and a single day selection on the screen). The Dimension 'by columns' is 'Phase…
-
Visibility Property enhancement: "gone" element
The idea involves enhancing visibility property of objects by allowing the user to hide an object (through a flag) nately shifting all following ones upwards, just like in a standard css "display:none" property. This need comes from several requests recieved in order to easily be able to edit a dashboard by choosing which…
-
MENU TRIGGER
Idea: allow developer to add 'trigger' or 'procedure' to the menu object that is run each time a menu item is selected/clicked. Why?: Currently the menu object is very limiting. You can only apply selection, or not apply selection. That essentially assumes that EVERY screen you wish to go to needs the identical selection…
-
Missing options in bubblechart
Hello, I'm writing about the bubblechart object; currently, it's impossible to increase the size of the bubble radius, and also of the bubble markers. The size of the bubbles can be determined by a certain quantity in the layout; the point is that the quantity seems to change only the relative size from one bubble to the…
-
@Select does not run
Dear Board Friends, I have a strange problem: in one specific database I try to use the refer i.e. @Month in a dataview but it does not run. I use Board 10.3 and I already checked relationship but the problem still remain. it is strange because in the previous version (10.1) it runs correctly and also in other databases it…
-
Improve the 'Cube list' in dynamic selection
Hopefully this is already on the list for improvements somewhere, but currently cubes are ordered by their index number in the list for a Dynamic Select (web version), even though it displays their name rather than index number. I'm going to guess that almost no one uses index, and everyone uses names. It would be better…
-
Using new MS Edge with Board
Hello I read in a discussion that "The recommended browser to use with Board is Chrome, using a different browser may well cause some issues." We use latest version of Edge, Chrome is not provided and maintened by our corporate IT. We still use Board Client, and plan web migration in the time being. My opinion is that…
-
Database, Backend Setup with multiple Entity Relationships
Hi Board Community, I need help on a specific backend, datawarehouse setup topic. I have to create a report which shows the cost per publisher and its respective country. My idea was to create an entity for publishers and one for country and map them via relationships, the cost would be added via a cube. In the end I want…
-
How do you get the column sum of a formula into a label?
Hello everyone, I want to see the sum of a column in a label, like in the screenshots below. The problem with this: The column contains a formula. Does anyone have an idea? The blocks are exactly the same in both layouts. If you need a cube-structure feel free to let me know. Thank you in advance Julien…
-
Pie Chart Prior Month Results
Hello On a screen I have two pie charts. One displays values for current month and the other I want display the totals for the prior month as a comparative to see how things are doing. I want this to be dynamic, but I am having trouble with this. Cheers ------------------------------ Jason Ferguson Management Accountant…
-
Menu object - improved colour/font options
When using a Menu object it always highlights the 'parent' level in white when 'expanding'. This causes issues when your font colour is white....and sometimes you want your font colour to be white. The object doesn't offer enough control over the colour or the font to be able to get around this issue. You only get to…
-
Adjust Relationships
Hi all, looking for a best practice to adjust the relationships of specific entities. I have the following use case: Publishers are linked via relationship to a respective Sales Office. Now the Sales Office of a specific publisher needs to be changed from AMERICAS to EMEA. I was about to do that manually by going to…
-
Option to open screen without layout refresh in development
Our partners are currently developing customer's screens with the combination of a screen to filter data and a screen to show the result (dataview). In designing/checking the result in a dataview, Board automatically tries querying ALL the data since the filtering condition is not applied in the case when we develop a…
-
Participate in a video case study (500 points)
Participate in a recorded interview about your company's Board use case, ideally at your office. In advance of the interview, the Board team will coordinate with you on the details of the interview, including questions to be asked, expectations for the video recording, and the anticipated time requirement. After the…
-
Collaborate on a press release (250 points)
Collaborate with Board staff on the release of news about your company. We share different types of news on our site featuring customers, including new customer announcements, project go-live stories, or achievements that our customers have made using Board. The Board team will reach out to you to learn more about the…
-
Be a sales reference (200 points)
Speak with a Board prospect over the phone and share details about your journey in selecting and implementing Board. The Board team will work behind the scenes to match your company and use case to that of a prospective customer in the deep stages of evaluation. Your interest in participation will be confirmed before the…
-
Share a quote about Board (50 points)
Provide a quote about your Board experience that can be used in publicity (website, social media, blog, etc.). The quote can capture any moment during your Board journey, from the selection process to benefits realized. The Board team will inform you when and where the quote will be used. You will receive 50 points for…
-
Looping a procedure through non-time entity without Nexel
Just wondering if anyone in the community has found a way to loop a procedure through a non-time entity WITHOUT using Nexel writeback or extract/reload? At the moment we have to use Nexel Writeback to populate a cube with RANK-Count to get something like the below. Entity Cube Val Mbr1 1 Mbr2 2 Mbr3 3 Mbr4 4 Clearing and…
-
Option to disable 'auto updating' when developing in web
Currently whenever you do anything in the web it starts to auto update the screen. It would be good if there was an option to STOP this from happening (if desired) and only update manually (much like you have the option in Excel for calculation). It slows development down a lot in a few ways.* There are many times when I…
-
Gauge Chart Alerts
Hi All, I can't seem to get alerts to work on a gauge object in the same way that I am used to with the old cockpit object. I am able to set the alert one of the display blocks but it doesn't have any effect. Any help would be greatly appreciated. Thanks, Ryan ------------------------------ Ryan Hinch Consultant Simpson…