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.
-
Connection Board to Azure fabric - cloud SQL DB
Hi We have Board on Azure cloud supported by Board. We are moving from our old ERP solution to MS Dynamics 365. The data will be moved from Dynamics to the MS data model and to Azure Fabric – cloud. Are there any others that have made the connection from Board to Azure Fabric? We are struggling to get the connection to…
-
Not able to perform average
I have taken one solution building task Months are selected like 12 months from jan to dec I have taken cargo revenue jan to dec each month has equiavalent revenue Now, I need to calucate seasonality index = Revenue of month Jan/ Avearage revenue from all the months I am not able to perform the action , Please help me with…
-
If then else in procedure: which role plays the current active selection?
Dear community, I am wondering which role the current active selection plays in an If then else procedure step. According to the help https://help.board.com/v14/docs/execution-flow-action-group#if-then-else , the selection context existing (user profile, screen selection, Pager's selections…) when the step is run should…
-
Selection by a cube
Hi, I have a screen selection by a cube. When I do another selection on the same hierarchy / relationship it removes the cube selection. Hotel is part of a country I select through a cube all active hotels. When I now select only some countries it shows inactive and active hotels because the cube selection has been…
-
Flex Grid equivalent locked by Options
Dear Team, Can someone please explain to me the equivalent for locked by cells found in dataview In flexgrid , we have only cells locked by What would be the equivalent of the dataview to flexgrid. Thanks Khaleelah
-
Incorrect values
I am building a solution in the board platform, I have set up the procedures correctly taking cargo previous year multiply with growth factor and target should populate the result but the result is incorrect the values are not correct. the growth factor is 10 Why is the value is incorrect?
-
Why does custom selection script @user requires the "Administrator" username?
Hello, i am working on database security profiles. I have a user_name entity in which a few of my business users are stored. I don't need all users to be in this entity. I want to implement the simple custom selection script Select user_name = @user, see screenshot below. But then i got this error message Warning!…
-
Not able to get the Data reader working.
Hi everyone, I have been trying to build a solution, but i can't seem to get the data reader configured properly. Everytime i run the data reader, the file name just disappears and the contents do not populate, else, the valid rec. shows 0 and the Disc. Rec. shows the entity numbers. What could be the issue? i am attaching…
-
Flex Grid - Totals
Dear, Im currently using the flexgrid which is great. Im facing small issues The totals are not inheriting the format of negative values nor adding the % sign. Also , how can i rename the columns , i need to remove the calculated which has been prefixed. Thanking you in advance to guide. Rgds khaleelah
-
i am building a solution in board i am not able to populate the data in the datareader
i am not able to view the source and file and run the data reader, i have attached all the screenshots please help me with this.
-
max item number blocked
Hello, We had an entity set on max item number no =auto. It worked well until one day the systèm blocked it to auto(471) and it didn't let us modifiy the value. So we did the following steps: 1.Runan "Extract all Cubes" action 2. Runa clear all Cubes 3. clear the concerned entity and the associated tree 4. Change the Max…
-
how to delete capsule tile footer?
I would like to delete the capsule tile footer: how can i do this? The tile configurator doesn't show any button to delete the footer: If i go into the footer's layout and click on clear layout, then i cannot save the empty layout, Board sees this as an issue: Has anyone already met this issue? Which solution(s) exist(s)?…
-
CLEAR RDB-cube?
How does the "Clear " function work on an RDB cube? Will the table be cleared in the data warehouse if we use that function?
-
Cartesian chart without any entity in Axes -> Category axis shows cube value
Hello, I noticed a strange behaviour and wanted to ask if it is only happening to me or if it is something more general. My layout shows two cubes: The Axis are empty: is it normal that the value of the first cube is shown as category (= horizontal) axis value ? I would expect that the axis shows no value. or is it a bug?…
-
Level 200
Level 200, Module 204: How do I upload the data into the data reader?
-
🚨 1 security filter's unexpected twist will leave you intrigued!
Hi everyone, I think it may be useful information for some of you to know that the 3 options under Security Filters actually doesn't have the same behavior! In fact the "Select Entity based on Cube" feature can be by passed the user itself! And it's by design *! By following the step bellow : Open a layout editor (where…
-
Problem with Yearly moving total function
Hi i have some issue regards the function Yearly moving total Below you can see the data in Q1/25 ( there is not other data after Q1/25) but after i use the function the value inside Q1/25 will be null even if i use the cycle function→ (the cycle is set to 9000) Do we know the reason behind this? thanks
-
I am getting two missimg errors in the relationship part
please help me with this, how can i correct this
-
Transfer Value from 1 Reporting Unit and Department to another RU and Dept
Hello, Is it possible to transfer or map a Staff Cost to a different RU and Dept. using Dataflow and then apply the corresponding FX rate? Please see table below Currently, I have a Temp Cube without the RU and Dept and store the value in there. And then I intersect it with Temp - To cube which has the flag for the To…
-
Selector - select/search for multiple entity members
Hi, Which filter option for the search function in a selector can be used in B14 to select multiple entity members? Note that in the example, I’m not search exact ID or DESC, only that it contains Jan or Feb. In B12, we could use a pipe (|) as a separator.
