-
merge data from multi data source
Hello I want to merge data from multi data source. the replace option in datareader clear the Infocube cells so not suitable for import multi data source. I have two cubes, 'tmp' and 'data'. I made the data reader loading data from data source to 'tmp'. and I made the data flow procedure. Datail is the following, block A:…
-
Unable to display at the same time the split per month and the last month selected ?
Hello all, We are trying to migrate our reports from our previous FP&A software to Board and are facing an issue with a requirement which seems to be basic : The requirement of our management is always the same on nearly all their screens : * 1. The user should be able to SELECT the month he want to see (eg April) * 2.…
-
"My View" automatically applied on screen opening
It would be really helpful to add an option on My View feature that allows to automatically apply the last My View saved by the user to the screen for the next openings. In this way user does not have to always restore the view every time he opens the screen and from another option he can go back to the original view when…
-
"Export data to excel in flattening mode" missing from dataview menu
Hi guys, Need help. I am using v9.1.0. How come I don't see "export data to excel in flattening mode" option when I do right click? Is there some settings I need to do in server? TIA!
-
Total display
I would appreciate it if I could choose whether to show or hide each of the total and grand total. Thank you.
-
Group rows background color of DataView
I would appreciate it if I could set the background color one by one when there are multiple groups of DataView. For example, set red for GroupA background and blue for GroupB background. Thank you.
-
The angle of the category label of chart
It would be great if I could set the angle of the category label of chart to only 45? and 90? to any angle. Or make the steps finer (30?, 45?, 60?, 90?, etc.). Thank you.
-
SQL load, error log
Hello All I get rejected items while loading data from a SQL table. I have ticked the log file option but I cannot see where the log file is saved (Using BOARD 11 - Cloud) I looked at the logs on the board cloud administration portal but cannot see anything under SQL logs. When I load from flat file it generates the log…
-
NEXEL on Web
We recently upgraded to 10.6 and I had a dataview with a lot of cell based deep entity nexel formulas, pulling from other columns (blocks). I accidentally deleted an entity member. On re-adding the member I can not find how to re-add the nexel formulas associated with it. This was very easy in the client version. How do…
-
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…
-
Howto: Embed a report on other sites
Starting from Board 10.1, Board web reports can be embedded directly in other webpages, such as enterprise portal, customer portal, intranet portal or other public websites. When you embed a report, it will appear as a box on your page that contains the full contents of your report, including charts, tables, and other…
-
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…
-
Restrict file upload size by users
Request to implement an (administrator-configurable) attachment filesize limit to prevent massive files (movies, films, executables) being uploaded into Board
-
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'…
-
Link Horizontal & Vertical Scroll Bars Independantly
It would be great if I could link the Vert & Horz scroll bars independently of two data views. For instance, I have two dataviews that share the same columns but different rows running down the page, but I don't want them to scroll vertically at the same time, but I do want them to keep the same column alignment.
-
[Cloud] Automated backup of capsules
Currently you can only manually backup capsule in Cloud! It's a mandatory feature since: * in production * in development, you can loose work in progress due to user mistake or lack of synchronization between developer . Also manually back up a project with more than 10 capsules every day is tedious and unrealistic to ask.
-
BUG FIX: After adding using drag&drop you can't sort or filter on this block.
After adding using drag&drop you can't sort or filter on this block. You are force to do a modification somewhere for the lists to refresh and be able to see the block in the list https://www.youtube.com/watch?v=M13w34HWNYM
-
BUG FIX : Allow to Save comment in procedure editor without changing anything else
Everything is in the title but just in case : https://www.youtube.com/watch?v=-tTJH2kaoMQ
-
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…
-
Web Designer : Improved selection/deselection of object
1. After pasting object(s) make the object(s) already selected. Not the one you copied if they are from the same screen. 2. When using a mutli object selection in a screen : Allow the use of ctrl key+ click to deselect object(s) at least in the left "Screen Objects" panel, ideally also in the WYSIWYG too. Would help a lot…
-
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…
-
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…