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.
-
Use Fabric as a Source for Board OnPrem 14
Hi to all, i want to use Fabric Tables and Views a a Source for Board OnPrem. Has someone successfully connected? How did you proceed? What did you use? SQL or API? Kind Regards
-
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
-
Object/label positions changing when exporting PowerPoint
Hello, I am attempting to export a screen to PowerPoint, but the position of the labels I have on screen keep moving. How can I prevent that? Thanks, Chris
-
Board 12 to Board 15 migration - old #/upload screen not editable
Hello everyone, I’m currently migrating an application from Board 12 to Board 15 and I’m facing an issue with an old upload screen accessible through a URL like: https://myapplication-c1.board.com/#/upload The screen contains several upload file sections “Requests”, “Present”, “Budget” etc.) with Upload buttons. The main…
-
Fit to page not staying
at our office, the finance team desks all have ultrawide screens that are 21:9 resolutions. This creates a lot of issues for navigation in Board, because we have to keep on clicking “fit to page” everytime a new screen is opened or refreshed. It becomes unusable for users because the menu we have on the top of the screen…
-
Default fiscal period cube + pager
Is there a way where I can apply a default fiscal period via dynamic screen selection based on a cube but also have a pager that will still show the other fiscal periods? I typically need to make a compromise when applying dynamic screen selections based on cube. If i make a mapping cube to assign a default fiscal period,…
-
Quarter to date with detail by, but having one block referencing full quarter.
Hi! The intent of this screen would have been to see what QTD actuals are as of month 2 (february) close. Compare february QTD actuals to february QTD forecast Detail #1 by month Compare full quarter forecast to QTD actuals to then calculate remaining forecast to spend I believe I can do #1 by having two pagers, one for…
-
Disable group alerts doesn't apply to dataview with multiple rows
Hello, i have a problem with the color alerts in a data view object. In the multiple entities by row options of the data view, disable group alerts is enabled, which to my understanding should disable the color alert in the group headers. But in my case it doesn't. In fact the disable group alerts option doesn't change…
-
Identify hightest/max value of a cube - without time entity
Hi community, I have a source cube (data type single) with four entities, but no time-entity in it. I want to identify respective to save the highest value/number of any existing entity combination of the source cube in a target cube, which has only a dummy entity. I tried it with the "MAX(a)" algorithm as expression, but…
-
Distinct count total
Hi there, i created a few blocks which are you using aggregation distinct count on an entity. when i am adding multiple entities into rows i don't have totals? How can i fix this? Secondly the Grand Totals don't make sense. any idea why? maik
-
Global user meta variables not working in new data model security
Hi everyone, I'm currently facing an issue with Data Model Security in Board and would appreciate some help. I created a new Data Model and I want the security behavior to work exactly like in one of my existing models. In my existing model, data visibility is restricted successfully based on global User Meta variables. In…
-
Board 12 to Board 14 Data Model Migration – Best Practices & Feedback
Hello Team, We currently have a data model that was originally created in Board 12 and is now running on Board 14. If we create a new data model directly in Board 14 and then restore the existing data model into it, do you see any potential risks, compatibility issues, or unexpected side effects? Personally, I do not…
-
Reason of error - Requested database is currently being modified by another user
Hi Team, I'm facing error while giving exclusion selection of an entity member from screen or from procedure. Although error is not coming on selecting member in inclusion mode. Please refer to attached screenshot. Error is given below:- Requested database is currently being modified by another user
-
Procedure getting stuck at a particular SQL Data reader step
a { text-decoration: none; color: #464feb;}tr th, tr td { border: 1px solid #e6e6e6;}tr th { background-color: #f5f5f5;} a { text-decoration: none; color: #464feb;}tr th, tr td { border: 1px solid #e6e6e6;}tr th { background-color: #f5f5f5;} Hi everyone, Has anyone faced a situation where a Data Reader shows 100% progress…
-
Do datapickers work with fiscal offsets?
I have a datapicker that references a cube that stores diluted shares by fiscal Year. When I try to do a trended P&L, where I duplicate the P&L cube and apply time functions for previous years, everything works except for the datapicker row, even though the cube it's pulling from is dimensioned by the appropriate fiscal…
-
Board Excel Add-In Pagers
Is it possible to have the Pagers appear automatically on the sheet in Board Excel Add-In? Right now, I am only able to configure it so you have to click Pagers for them to appear. You must do this again when you exit and come back to the sheet.
-
Need help with Report building, particularly Total By
Hi, I would like to ask for some tips about the best practices with regards to building an archive report. We have an archive cube with the following 6 entities: Month, Reporting Year, Version, Business Area, Currency, PnL. PnL is the biggest one with <200 members, all of the others are <20 members. I have a screen…
-
Create a ytd calculation in board
Hi, i want to ask what is the best approach to create a YTD calculation from my cube? I already have the Cube but it still calculates per monthly.
-
Validation on horizontal Checkboxes
Hello I had to apply a validation rule on a cube (checkbox) to ensure only one choice is selected. However i need to enable the ROWTOTALS for it to work (and the validation only works when save/undo is enabled) Is there any way for me to lock the column totals. I cannot hide it otherwise the validation rule does not work.…
-
Is there a way to change the default path for files exported from Board?
Each file (pdf, excel) exported from Board go into a user's downloads folder. I would like to configure the export path to a different folder which I can then build trust center policies around. This would support our ops team that has to download dozens of reports during ME close and has to enable editing on all exported…
