-
Convert varying to Text
Hi All, I want to import values from a postgre database using Data Reader. However, some values are in varying format. How can I convert them to text in the Data Reader?
-
Workflows
What are some common workflows? What are some ways procedures have been used to facilitate a process or user experience?
-
How do you build a report that shows Data in multiple Rows instead of columns?
Hi, We are trying to build a report that has multiple Data Selectors say sales and sales PY that show up as rows. Currently the data selectors are showing up as columns. The report Axis is "BY ROW nothing" and "BY COLUMN Quarter Month" The data has two Data Selections. Sales and Sales with a time adjust for PY. When you…
-
Accessibility Requirements according to EN 301 549 (European Directive)
According to the European Directive EN 301 549, we are obliged to meet Accessibility Requirements for people with limited or without vision as well as for people without perception of color. In general, software and web applications shall be perceivable, operable, understandable and robust. Those criteria are specified in…
-
Map chart issue
Hello Board community !!! Im using Board Version:12.6 Revision 0.0.085662 Im trying to create a map (openstreetmap) showing sales by country. The maps is not working and i have bubbles stuck in the corner of the map. I followed all the steps showed in the "tips and tricks" video of @Sudhir Raju. Here is the settings: Any…
-
Problem: Impossible to use special characters on Labels, Block Formats and others
Hello community, Board application is refusing the use of special characters that we need to correctly write in French (e.g. é, à, è) or even currency symbols (I tested € and £). Any time I write a special character inside a label, new cube name, block format, security role, etc, Board will clear the field. This is a big…
-
Data View selection
Hi All, I have the following task: We need a Report -Screen with two Data Views and the following three Pagers for selection: Year, Industry and supplier Two Data Views with supplier in lines and value in column with difference blocks. The first Data View should show the figures of the complete selection. The second Data…
-
Cycle 3650
Hi Board Platform Does anyone know what "Cycle 3650" does? I attach the details of the dataflow where I found this. There's a selection on 40 months (I assume all picked) prior to the dataflow
-
Messages in BOARD 14
Hello, I just saw the Customer Connect Webinar on BOARD 14. And there it was said, that the Pop-Up Messages will now appear in the bottom right corner, instead of the top middle. Is this hard coded or can we adjust that. We use those messages a lot to guide users through procedures, so I want them to pop up in their direct…
-
Analysis shows nothing
Hi Board Platform, do you know what could be behind this situation:
-
Is it possible to have a different layout for the drill-through and main dataview?
We want to filter the drill-through based on a specific block so we want to create a filter block. We want the drill-through to hide rows where the Fiscal YTD is zero, and we want the main dataview to filter where WS P&L Filter is zero. Is it possible to have a different layout for the drill-through and main dataview? We…
-
Rounding not working in dataflow with BOARD 12.5.1.1
Dear all, I am using a BOARD Cloud instance. I have a cube V10, type double. Since this cube manages quantity in a planning process, I need to first perform Qty: V10 = value\price then I need to round the value. I have tried this: 1. Define a dataflow with round(V10,0) 2. Copy the value from the cube V10 to another cube…
-
How to flow data among blob cubes using dataflow procedures ?
.
-
Dynamic Selection
Cloud Version: 12.6 0288217 In a Procedure, I use a Dynamic Selection within a Selection (see screenshot 1). The cube, the selection is referring to has one entity (DustinUser). But no DustinUser is ticked in the cube. The cube is totally empty. When running the Procedure (Step 12), all members get selected (see screenshot…
-
How do I change the font size in a gauge?
We've got 2 gauges in our dashboard and they seem to have different font sizes. The size of the gauges is the same. However, the option to change the font size is disabled (in light grey). Sooo: Where do I change it then?
-
Cube Visibility & Cube cells locked by
Cloud version: 12.6 0288217 Hello, I can't get Cube Visibility (Deny cell editing in Database Security) combined with Cube cells locked by to work, even if the cubes are not conflicting. This is the error message shown on the Screen when you log in as a User (not Developer). The error message itself is not explanatory. Is…
-
Hint on calculation
Any ideas on how to do this type of calculation in a dataflow where C2 and D2 and so on are calculated from previous month from row 5. I can only get it to work if i calculated each month in a loop, but there must be another way?
-
Does B12.6 or following versions allow to refer to on descendants of an Unbalanced Hierarchy?
I'm currently working with B12.4 and we cannot select descendants for an unbalance hierachy in the refer to option of a block. Does anybody know if this has been fixed in B12.6 or subsequent versions?
-
Edit Max Item Number
Hello, I noticed that it is not always possible to edit the Max Item Number of an entity. In which cases the max item number is locked ? Is there a way to change this behaviour ? Thanks for your help. Ian
-
Excel add-in data entry
Excel-add-inに他のExcelファイルで作成した複数の値をコピー&ペーストしたいです。 Excel add-inに直接手入力を行うと背景色が緑色になり、保存を押下すると保存される認識です。 ですが他のExcelファイルで作成した値を複数コピー&ペーストすると値が消える+緑色セルにもならず、入力が正しく行えません。 他のExcelファイルから複数コピー&ペーストすることは不可能なのでしょうか?
-
How can I calculate difference between two dates?
I want to calculate the difference in days, hours, minutes and seconds between two datetime stamps and I would be very interested to know how others have approached this. Currently I seem to be contemplating a solution which first subtracts one date from another to get a decimal. Then I would convert that decimal to days,…
-
Compare date in column algorithm
Dear All, I have 2 cube, the first cube is a date cube with one dimension is article, the second cube is single cube with 2 dimensions are Month and article. I want to make a new single cube with 2 dimensions are Month and article. i want to fill the value in new cube by second cube with the logic is if the month in second…
-
Connect Power Bi Connector to Local host
Hello, Is it possible to connect Power Bi with the local host server?
-
Start screen in Google with Board user and password
Hello all, we will start one screen in Board with a desktop shortcut. The problem is, that we must enter the Board user/password. Is there a way to pass on the board user and password? Kind regards Stefan
-
The Database size got reduced from 24 GB to 19 GB after extract and reload of the database
Recently i performed Max item number change for few entities and for that we extract all of the database and do this change and then reload the database. There is no loss of any data for me, nor there is any issue but the only thing i observed was after the reload of the database the size of database got reduced to 19 Gb.…
-
❓Follow-up with Security Filters and Refers "To"
A coupe of week ago, I post this (also ticket 00095180 ) However now that the 17 novembre patch fixed the issue we finally resume testing on the security again. While the patch improved on the situation we have one edge case that seems strange : when a user end up with no value in the entity Etablissement in his security…
-
Relationship changes logs
Hi Board Expects. Quick question: does any of the log files provide the details of relationship changes between entity members? A DB log shows the entity names and shows the record that the relationship was modified. Can we see anywhere the members of child and parent entities? Eg. we have Item → Item Category…
-
Impact analysis: Oops we are yet ready to analyze this Datamodel..
Hi all, After a restart of the service, i receive this message when i navigate to the impact analysis (never seen this before). Also, when looking at the analysis of my cubes, everything is 0. Is this normal? How can i solve this? I've been waiting for a while already.. Andries
-
Integration with R - Load data doesn't work properly
Hello, I experimented the following problem. After execution of R statements, the DataReader doesn't work properly, but laods only a few items. I'm sure that R dataframe has more the 100 items, because I write them on a file. After the data loaded, DataReader show as number of rows loaded the right number, but in the cube…
-
BOARD utilizing AI (Artificial Intelligence) and ML (Machine Learning)
Hi, Are there any instances of BOARD utilizing AI (Artificial Intelligence) and ML (Machine Learning) capabilities in any demo across any sector/ industry? We work in the fashion retail industry and have been constantly asked this question in many of our Pre-Sales meetings. Any help/ lead on this regard is highly…