-
Design reports: formula for "Right" side of a cell
Hi Board Community: I'm designing a report. I have a column of info that has a code like this: 1021981.001.002.003. We call this entity "Subworkplan." I want to create a formula (or algorithm?) that will show me the right 11 cells, of what is in this column. For example, show me 001.002.003 in the above example. In the…
-
How to change the header of a dataview between forecast and actuals
Hello everyone, I am building right now a 3+9, 6+6,... forecast and I want to change the header of the dataview accordingly to forecast and actuals (e.g. 3+9 forecast first 3 months actual, last 9 months forecast). The cube can be the forecast cube for both actuals and forecast. It is just necessary to display the header…
-
How to show Top 11-20 Entity Members
Hi everyone, I have to show the range 11-20 Clients by turnover in a chart. Is there a dynamic way to do that, without a procedure but using layout functionality? Thank you, Chiara ------------------------------ Chiara Fabris Consultant KVALUE SRL Italy ------------------------------
-
Printing a presentation to pdf landscape
Is there a way to change the default orientation when printing a pdf from a presentation? I'd like to use this for our financial package and have to generate paper copies for some of our leaders. ------------------------------ Ian Bradley VP Finance (CFO) T&S Brass and Bronze Works, Inc United States…
-
Dataflow to Cube with Extra Entities
Hello I currently have multiple cubes with specific data that I want to populate into a single cube. The issue is that I want multiple cubes to flow into the single cube and be represented as different entities (e.g Opening balance, closing balance, Inputs, Outputs) I am unable to find a way to Dataflow the 'Inputs cube'…
-
Time function doesn't work
Does anyone know how to deal with the fact that enabling "Time function" does not work? The dimension of sales cube is Month. When time function enabled, the data will be lost. Board version is 10.6.3.40939 Has anyone else had the same problem? And is there a solution? Thanks, Shuyu ------------------------------ Shuyu…
-
Additional calendar in Time Range
Dear All, I'm currently working on a customer context that needs 2 different calendars:* One starting in Jan (FR) * The other one starting in Mar (DE) First, I was wondering if you already met this request and how Board has been set up to deal with:* These 2 calendars (same time range entity? another cube? date cube? make…
-
Code and Description in two different columns
Hi All, I have an entity "Material" with Code = ID and Description = Name. I choosed the option "Display Code&Desc" in my dateview, to display both. When I export the report to excel I get one column with Code and Description together. Is there any possibility to get two separate columns: one for code and one for…
-
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…
-
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…
-
@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…
-
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…
-
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…