-
Cubes groups sorting
Hi wizards of Board Platform. Do you know if it is possible to change the order on which cubes "Groups" appear on the layout config page (on the left when you open the layout of a dataview)? I'd really like one group of cubes to appear at the top of the list. Thanks!
-
Header Group Row
Dear Community, Is it possible to create a group Header that keeps specific columns together, as below? I am looking for the functionality that will create the DAY – WTD – MTD sections for me, in a dataview. Thank you in advance �� Kindest regards Alicia Meredith-Smith Business Intelligence Manager St Medius House, London…
-
Where's the Entity extract file?
Cloud, Version 12.6 When extracting an Entity, where does the file end up? According to documentation, it ends up in the default download location, but I can't find the file in Z:\.
-
Display all the mappings of the Mdb items in the data readers
Hello together Is there a way to display all the mappings of the Mdb items in the data readers? Is this information stored somewhere in a folder on the server? Many thanks and best regards Oliver
-
Rest API Integration into a cube in Board directly.
Hi, We have set up a Rest API call that bypasses the pipeline and pulls data from a different model in our Board instance. Is it possible to take the payload(source data) that we get from the Rest API and push it directly to a cube in our datamodel? We do not want the payload to be exported into an output file that is…
-
How to dynamically display the user selected value when a data view is set as master object
On the left I have a P&L hierarchy driven report set as master object. When I click on a row, the charts on the page change. I would like to display the current row that was click on in the master object. Trying this, no luck: @Selection_Ex(Layout="P&L", Block=" ") Version 12.6 Thanks! Matt
-
An uploaded zip file - when the user downloads it, how can we control what the filename will be?
A user can upload a zip file to Board. When they do that, the original filename is lost. The new file name is generated how? Can this be controlled? For example, could the zip file have a reference number derived from where it was uploaded in Board? ------------------------------ Michael Gerrard UNHCR http://www.unhcr.org…
-
How to compare 2 different cubes to show an alert?
Hi Community! I am working on figuring out a way to compare two different data entry cubes to show alerts. The goal is to have one DE cube to match the sum of by Month DE cube values, and if the sums don't match the alert or notification will appear. Are there any ideas on how would be best to approach this?
-
Order of Reporting Accounts on P&L Sheet
I am trying to add two new lines to the P&L sheet in specific spots, and thought they were ordered by the Reporting Account code number. There does not seem to be a correlation between the code number value and the order. Does anyone know the logic behind it?
-
Dataview Layout: Impossible to apply a filter when an aggregation function is used
Hello community, I'm quite new here. if this is not the right place for this question, please redirect me. I have a Dataview layout in which I use an aggregation function to display the average value for my block along the time entity "Month". When I try to apply a filter to this layout, it has no effect. However, when I…
-
Hmmm... can't reach this page. Localhost refused to connect
Hi all, I have installed the on-premise version 12.5.1 on my new laptop. The Board Engine and Board WebApi Engine services are up and running. When trying to open Board in the web browser, I don't even get to the Board login. A message pops up saying "Hmmm… can't reach this page - localhost refused to connect". I've…
-
Does BLOB cubes are stored in RAM or in DISK ?
Hello, I have a lot of BLOB which purpose is just to to load an extract cube file exported few seconds before on the dataset folder on the server So end user can retrieve that cube export withtout having to connect to the server. ⇒ Does files stored in BLOB cubes are also stored in RAM or only in DISK ? Means If I have…
-
Can we change data through dataflow using RDB cubes?
Hi All, Thanks for reading my message. I'm developing one dataflow, using RDB and MDB cubes, and I'm not able to change or update data into my RDB cubes. However, I can make changes using a direct data entry. Is it possible to use dataflow to delete, update or create rows into RDB cubes? Thank you.
-
Is there a way to extract a file name in the data reader ETL?
Hi Board Community! I am working on creating an ETL logic to dynamically extract months to a correct fiscal year. The complication comes in because there are some of the future years that need to roll up to the year end of the particular (past) year. I know that there is the formula in excel that allows you to extract the…
-
Importing Data from PowerBI Dataset
Hello, has someone an idea or experience in importing Data from a PowerBI Dataset as Data Source? Best regards
-
Cube Visibility based on User
Hello, According to documentation, it should be possible to apply Cube Visibility based on User. See screenshot below. But I can't get it to work. Even if I'm logged in as Patrick Stewart (as in the Board case below), and I deselect Patrick from Cube "User enabled", I will be able to see whatever is ticked in the Granted…
-
Net Present Value
Hello, I've been trying to find documentation on the Time Function Net Present Value - what it does and how it works. Can't find any documentation. The function seems to be available in a Dataflow, but not in a Dataview. Do you know? Thank you
-
What is the best way to setup a demo database?
We would like to setup a demo copy of our database where we can demo to user groups but mask customer data. Is there a best practice way to achieve this?
-
Is there a way to default the naming convention of exported excel tabs to code for the entity export
When exporting a Board screen to excel and choosing to page by a given entity that within Board has been set to "code" as the default setting for that entity, the exported tab pages within the excel document appear as the description of the entity and not the desired code of the entity.
-
Data reader failing with error "ReadGo4EseguiCUBESdo failed for ddv" in diagnostic log
I have a client where SQL data readers started failing to fully load data yesterday with the error below in the Diagnostic log. A trace in SQL shows the queries executed properly and the other Board logs show the correct number of records. No other functionality in Board appears to be impacted. The client is using 12.4.0.…
-
on Prem Board portal to upload file feature
Hi there, I would like to know is it possible to allows file upload function thru my Board portal? Situation: A screen layout at my Board portal to allows Excel file upload thru portal. Then the board portal will show the uploaded data in table form. Example, my screen to have template allows user to download the template.…
-
Moving a new model from sandbox to production
What is the best method of moving a newly developed model from the Sandbox environment to production using vs 12.6 in the cloud?
-
Where can I download the latest onpremise pack
Hello, My company is a Board partner, and I would like to download the latest On premise installation pack (>12.5) in order to get a hands on experience. Could you please direct me to where I can download it? Best regards, Alexis Leperlier, Primexis
-
Translation : Having different german translation per country
Hello, We are using cube language feature for entity member translation with following language : EN / FR / DE Now, we have some country requirements to have german translation that should be different per country, eg: German for Switzerland German for Austria German for Germany Is-it possible ? regards julien
-
Board Office Add-In no longer works
Hi, for one Board user we had installed the Office Add-In 12.5 and that worked. The Board tab was visible in Excel. But from one day to the next the Board tab disappeared from Excel. I uninstalled and reinstalled the Office Add-In, but the Board tab no longer appears in Excel. However, it was working until recently. What…
-
Excel AddIn Documentation
Hi Boardies We are currently trying to solve it with the use of VBA since no native solution came to our minds and we want to automatize it as much as possible. The problem is following: A single table (lets say, country, year, period (BoP, A, EoP)) grouped by countries on one screen. From the Excel sheet the table should…
-
Is it possible to add a "+" symbol in front of positive values?
Using the image above as an example, is it possible to add a "+" value in front of the 89.0% without writing it as an text algorithm in the data view? (as this is requested in multiple views) I understand it's possible to add a prefix in block formatting however that wouldn't recognise a value as <>0 so it would place a"+"…
-
How to also export the Layout settings to Microsoft Excel Workbook for BOARD Add-in?
Hi, I am currently exporting data from my report directly into excel. I can then connect my Board office add-in to the table and apply selections and everything possible using the office conector. The problem that I am having is the value formats. In my report in Board (online) I have parenthesis instead of the minus…
-
NEXEL - Send Summary Results To...
NEXEL has a function labeled Send Summary Results To:. See the last line of here. Has anyone had any luck with this functionality? How about NEXEL Crossview? nexel
-
How to convert Board tickbox to a flag in Excel
Does anyone know how we can convert the tickbox column from an xlsx file into a binary flag? When I make column b = a, I get the same whether the column is empty or not. A user exported the file so I'm not sure if they can enter the layout to change the column appearance. Thanks
