-
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…
-
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…
-
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…
-
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…
-
Custom selection script
Hello, we'd like to set up a security concept where different users can see same projects. It depends on which user group the relevant users belong to. Everything should be dynamic. The model shows my entities (blue) and the content of them. In my example I have three users which belong to two different user groups and two…
-
Problem with Diagram Titles
Hi all, I have a massive problem with editing and deleting of diagram titles. For me it is not possible to edit the text of already existing diagram titles (see first screenshot) and if I try to insert a new text in the correct field in the diagram layout field, I can't delete or edit it anymore (see screenshot 2), because…
-
Board Mailer Service doesn't start
Hello everybody, When we try to start Board Mailer Services, we get the following even in our event log, and the service crashes. All the other board services start without any problems. We're using windows server 2012 R2 std 64x. Any help is appreciated. Application: Board.Mailer.Service.exe Framework Version: v4.0.30319…
-
Colouring in Data Views
Here is a question from @Alicia Meredith-Smith: Hi team, I am using a data view to display WTD, MTD and YTD information. I have 2 entities on Rows, a Group and a child. I need the Group row to be a different colour to that of the child below. Is that possible? Thank you so much! ------------------------------ Sandra Bartl…
-
Repeat Parent of Nested Items - Like Pivot Table
Hi, I'm a new Board user. I have the following Layout that I'm doing in Excel-Board add-in. Under the By Row, I have our company's categories and each customer under that category (i.e. Toys -> CustomerABC). I'll be linking this table to another tab in this workbook where I need to pick up this combination via a sumifs. Is…
-
End of life support
I have inherited support of our Board BI implementation, version 10.3.0.50803. Can anyone tell me when this version runs out of support. Thanks. ------------------------------ Gary Juleff Data Warehouse Reporting Analyst IMERYS MINERALS LIMITED United Kingdom ------------------------------
-
Automated Filter (Board v10.1.2)
Hi Board Community, I have a screen which shows weekly results in a graph. The graph is always showing the past 6 weeks. This timeframe is updated manually by using a Filter Cube on the Week in the layout selection: I am wondering if it is possible to automate this step in anyway so that the manual process can be ignored.…
-
Pie Chart without Axis Configuration
Hi together, just a simple question this morning: Ist there any way to configure a pie chart comparing two measures (blocks) without having a dimension set into the axis tab? I just want to compare measure a with measure b: Thank you and best regards!
-
Opening Multiple Instances of Board
Hi all, How do I open a second instance of the Board client (ver.10.3)? Should be easy, but it's just not happening - I'm almost embarrassed to ask :) Thanks ------------------------------ Andrew ------------------------------
-
Clean old databases
Hi, I have a couple of databases in Board, which I don't need any longer. Is there a way to delete this database so that it does not appear in the list of databases in Board? Thanks Mathias ------------------------------ Mathias Flintrop Senior Financial Controller Smaato Inc Germany ------------------------------
-
transform seconds into hh: mm: ss format
Hi all! I' d like to have some advice... I have a layout with a column where I dynamically calculate the number of seconds and where I drill this information from month to day, I'd like to show this information in the hh:mm:ss format, any advice? Thanks! Massimo ------------------------------ Massimo Palmi Consulente RETEX…
-
Horizontal/Vertical Style not working In Menu setup for folders on 10.6
Hello, I am using Board 10.6 Web Designer, I created a folder with some screens, and I would like to use Horizontal/Vertical Style for the folder I created In a screen or mask, but it shows nothing, it is just blank, all the other styles, such as Standard or Accordion are working well. Please see the attached screenshot.…
-
Selector on "Pop-up window" type does not display entity member on Board 10.6 Web
Hello, I tried to use selector on Board 10.6 Web, but it does not work on "Pop-up Window" type, it just does not show the member you selected on the selector. I know it is the same in Board Client, but is there any way to let it show the member if the single member selected? Please see the attached screenshot. Thanks.…
-
Calculation Domain Settings
I have been experiencing issues with writing new cells in target cubes after upgrading to Board 11. I am running the dataflow with the setting Limit calculation to tuples where values of at least one cube of the Layout are non-zero and then checking all the entities in the "Extended Calculation" dropdown. Am I missing…
-
Block Reference Automation
Hello Does anyone know if a Blocks Reference can be attached to a "Pager" Selector. Currently I have a screen with a week ending Selector, when changed I have to go into to the 'Data View' to manually change one of the blocks so the Reference only displays information for the last day of that week and change another block…
-
Automated Export of Dataviews to Excel or Email
Hey Board Community, i have a couple of dataviews on a screen in Board which I need to export to Excel and then send via email. At the moment the export is done manualy by clicking on the dataview and exporting it to Excel. This is very time consuming and a lot of manual work because I need to do this for multiple…
-
Messages and text mulilanguage
Hello all, is it possible to show messages and text multilinguale depended to the Security Profile settings? Thanks in advanced Kind regards ------------------------------ Stefan Batalia Board Administrator Optibelt GmbH Germany ------------------------------
-
10.6 vs 11.2 dataflow with different behavior
I create a dataflow that works fine in 10.6 and has different behavior in 11.2. The dataflow layout has a cube called Cubo1 type Integer, an entity called Seleccion1 which has 2 members and a target text cube called dummy2. with no selections, I expect at the end of the dataflow that cube dummy2 should have value "2". That…
-
How to Adjust Position (Fine Tuning with Arrow Keys) of Object in a screen in Board 10.6 Web Versio
Hello everyone, We just move Board to 10.6 Web Version. In the Board Client, we can adjust position (Fine Tuning with Arrow Keys) of Object in a screen, but it seems we cannot do any fine tuning on the web anymore, we only can use mouse to move the object, which is very hard to adjust the position of Objects with very…
-
Assigning new codes to existing Entity members
Board 10.x question: We have about 200 existing entity members across three Entities which require new codes due to changes in the source system. E.g. 12 Apples with code 12 will now have a code of 0010 - the member/description is the same but just has a new code. The existing members are referenced by Procedure…
-
line break in the web dataview
in the board windows client a line break is made in the dataview. Unfortunately not in the web client, how can you activate this?
-
NEXEL writeback not working
MAXIMUM URGENCY Hi everyone, I have a problem concerning the Nexel writeback. As you can see from the picture attached (which is the Nexel layout shown in the debugger), the procedure enters the writeback with the proper selection, therefore the layout is not too big. It writes correctly on the target cube but then, after…
-
Prior Year Total
I can current YTD (yearly cumulative value) and prior YTD (yearly cumulative value with prior year selected), but how do I get the full Prior Year total? I don't want a moving total. Eg; If the selected month is March 2020, I want the January 2019-December 2019 total.
-
Comparison day week from one year to another.
Hi ! I want to compare the date figures from one year to another year. For example, compared January 1, 2019 to January 1, 2020. This part works. However, I have a custom entity with the days of the week: Monday, Tuesday, ... and I want to compare Wednesday January 1, 2020 to Wednesday January 2, 2019. My problem is that…
-
Board 10.6 Web Service Error
Hi all, I installed Board 10.6 on a brand new machine (MS Server 2012), and configure the Web service as followed the instruction in https://community.board.com/viewdocument/how-to-setup-microsoft-iis-with-boa?CommunityKey=fce3410b-1520-47cb-bd8c-6cdd5a5b5ad9&tab=librarydocuments I can access Board via Web on the localhost…
