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.
-
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,…
-
FAIL BROADCAST:Action cannot be executed server side. Sending it to client using procedure mailbox.
I am trying to use schedular for broadcasting the emails automatically. so when i am trying it broadcast mail is getting failed. when i am doing it manually through the procedures tab , broadcasting is happening . can anybody help me with this
-
Board taking so much time for export text cubes and large size mdb cubes , is there any way ?
Board 14.4 is taking almost 2 hrs for extracting a text or large size mdb cube . Is there any way that i can make extract faster. I have tried using extract cube and dataset both , i didnot found a solution yet.
-
Exporting Quick Layout charts or showing the Chart Data
Hi, is there a none issue exporting charts with an adjusted Layout - through quick layout? It gives me always the dimensions of the original setup. I changed the chart axis from months to quarter however the Data chart is still considered with the setup axis - month Br,MAik
