-
Cool dashboard screenshots & efforts
Hi Board Wizards, could you please take a screenshot of your best dashboards in Board or one you found that was presented well? I am looking for some dashboarding inspiration. Thanks a lot!
-
Board API query: How to authenticate and use Secrect Key
Can anyone show me an example of calling the board api queries? I have am API user setup with a secrect key, and a query. example. curl -X GET "http://p-p-board4/public/ARGDB/query/indexPricesNymex"
-
@datetime
Hi Board Platform Wizards - Wondering if anyone could help me with the following conundrum... The standard @Datetime substitution formula you can use on layout file name exports as 'YYYY-MM-DD-HH-MM-SS' - Does anyone know of a way I can amend the standard format and instead export as 'YYYYMMDDHHMM' ? A client has requested…
-
Columns in Excel Add-in
Version: Board 12.6 Hello, I need help setting up a layout in the Excel Add-in.If I have two entities in the column field, I would expect one of them to lay on top of the other. But I can't get it to work. Without it, the layout is not so readable. Setting up the layout like this, I expect to have the Month on top of…
-
Week Description
Does anyone know if there's a way to get Week to have a description which shows the first day of the week instead of the Week number?
-
DB extract & reload
Hi Board Platform, do you know how can I clean up db sparsity, if I have a big application? I have cube extracts going beyond 30 Gb and Board can't load them back in?
-
Ranking Function
Hello Board Platform, I have a ranking function (cumulated value) in block b. I am then trying to create an algorithm in block c, which uses the value from block b. This block will not show. It seems if you try to reference a ranking function in an algorithm it will not show the column. Currently I am doing an export…
-
Weather Feeds
Hi All, Has someone successfully connected and ingested weather data to Board via an API? If so how did you do so? Thanks in advance
-
Google Analytics Integration
Hello Board Platform , has anyone successfully set up Google Analytics integration previously? If so can you provide some details on the integration steps?
-
Hide Home icon?
Hi All, do you know if the standard home icon can be disabled?
-
Documentation Request
Hi All, is there documentation on how to upload as capsule & DB to board cloud - Does this exist ? thanks in advance
-
Headers Orientation
Hi Board Community, does any of you know if it's possible to change the orientation of headers to display them vertically?
-
Aggregation: Distinct Count
Hi Board Platform , I'm trying to use the distinct count function within aggregation to give me number of weeks on sale and number of stores from a sales units cube (for an algorithm). Behaviour seems really intermittent, it seems to work, but then when I put the entity I'm counting on the row (i.e. put Store on the row,…
-
File Size Broadcasting
Hi Board Platform, has anyone ever encountered a broadcast failing due to the size of the attachment in the email? A customer has a new report including product images and we're thinking this might be the case as exporting a printable report makes it 48mb
-
Dataview Formats
How do you show the vertical lines on the dataview for the group group by? You can see in my image that the vertical line does not go through the parent that the rows are grouped by.
-
Standard Deviation
Hi Board Knowledge, does anyone know how to utilise the Analytical function "Standard Deviation"? I am trying to apply it but the results are not correct. I was wondering if anyone has manged to use the default functionality?
-
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…