Platform Q&A
This forum is dedicated to Board platform questions, generally applicable to all members.
Please select 'Yes' if a response answers your question to better identify possible resolutions.
-
Error when loading files from Azur
Hello, From time to time we have troubles downloading files generated with data exports from Azure with the message below. The same files works for several time and suddenly we cannot load it anymore: thank you, Catalina
-
What do the Longitude and Latitude do for Map Areas?
Hi there, I'm currently trying to use the Map-Feature more often. Espacially shapes. In the options for Map Areas I can choose shape name, Latitude and Longitude. But what exactly do the latter two do? As far as I understand it, all the relevant coordinates for areas are in the json-file you uploud into the Map-Object.…
-
Board 14.5 flexgrid pivot, multiple nested column groups
Board instance: dolby-s1.board.com Screen: Revenue Input It's great that it collapses the columns when I have a 2nd column grouping under it. But now, when i expand a column for instance, it brings it all the way to the left, even if I expanded Q3, it'll bring it to the left of Q1 and Q2. Before expanding: After expanding:…
-
How to join two tables in SQL Datareader in BOARD 14.6
I want to join two tables based on their multiple common fields.How to do that ?
-
Use Entity in Algorithm - Entity showing the count of members not the value
Hello, How can I get the value of Custom A Entity so I can use it in my Algorithm? Currently, I am adding it as a data block in the layout but it's showing the total members not the value. The by row has 4 Entities - Reporting Unit, Custom A, Group Account, and Comment. I need Custom A for my algorithm but when I add it as…
-
API Integration
We were loading the actual data in our application in BOARD with manual files. Now we want to integrate it with ADW Datalake. Please let me know how we could connect the servers with BOARD to fetch the data instead of loading it with text files.
-
How does BOARD handle concurrent execution of procedures?
Hello, We have a procedure which clears some cubes and then runs some data flows to reload the cubes. The procedure may be triggered by user activity. If two users cause the procedure to run at about the same time what happens? Does one run and complete before the other is executed? If not is there a way to single thread…
-
Pager / Selector change
Hi there happy new year. when changing pager selection or selector selection to whole screen is refreshing including collapsing dataviews. Is there a way to suppress that behavior.
-
Axis settings on multiple columns
Hello, I have a dataview with 2 entities in column and I want to display codes for both entities. I choose the display codes option in the settings but it applies only to one of the 2 entities in column. Is there a way to change this ? Thank you!
-
Schedular error - [0x-7ff8ef20] - The operator or administrator has refused the request
In schedular i am getting this result the procedure is not running , why this error occurs and how can i resolve this?
-
Error log
Dear, when im faced with such an error where can i see the complete error. Thanks
-
Flexgrid - Column Totals
Dear, Is it possible to show column totals without the need to group columns in flexgrid. Thanks Khaleelah
-
Waterfall Chart Aggregation Issue with Unbalanced Hierarchies
Dear Community, Does the Board Waterfall Chart handle unbalanced hierarchies correctly when it comes to aggregation? It appears that the object automatically sums all members, including subgroup totals, which leads to double-counting. For example, when the screen selection is set on the bottom line of a P&L, the system…
-
FlexGrid - Wrap column names
Dear, Do we have a means to wrap column names in flexgrid. In below snapshot, it is getting hidden when i resize the column. Thanks Khaleelah
-
Dataflow performance
Hi, We are running a dataflow which is lasting too much, about 50min. Something seems to be wrong but we can not figure it out. The goal of the Dataflow is to adda new entity to the original cube. The Dataflow multiplies the original cube with a cube (a kind of diagonal matrix) which contains a one to one relation from the…
-
Flexgrid
Hi there why i am not able to select for Month "Show all"? only when I remove Day (which is part of the relationship) it works.
-
Apply to Block - not working / applied on drill down
Hi, I have a procedure that switches an entity selection on a chart which is working fine. However, when I then use the drill down it doesn't pickup that selection. Any idea how to fix this? Or have a different approach? Thanks Maik
-
[Complex time hierarchy] : Bimonth + Quarter
Hi everyone, I’m struggling with a time hierarchy design in BOARD and I’m hoping the experts here can help me crack it ! Context : In BOARD, relationship logic is N → 1, which normally works fine… BUT in my case I need to introduce a Bimonth entity (every 2 months). So for a standard calendar year: 12 Months 6 Bimonths…
-
Is Row Number/Counter Possible in Export DataSet
i am trying to export a report and i want a row number, or else it would be helpful if i can insert the row number/counter values through data reader in etl
-
Unable to calculate Average, Standard Deviation, and Variance for Derived Lead Time Field
I have a dataset with two date fields: Load Date and Delivery Date. I calculate Lead Time as "Delivery date-load date". Now, I need to compute the following statistical measures for this Lead Time:Average (Mean), Standard Deviation,Variance. However, when I try using formulas like Subtotal (sub function code, x,…
