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.
-
Show Groups as unbalanced Hierarchy
Hello Friends, I understand we have a limitation on Board where when we use Show Groups as unbalanced Hierarchy as below,it will not show the level one if level 2 entity has only 1 member My P&L has 2 levels , was using the "Show Groups as unbalanced Hierarchy" for Totals, but unfortunately i have other members in level 1…
-
Month entity without year
Hi, I'm using a dataview for sales analysis. On the rows I have the year entity. I need to put the month on the columns, to get 12 columns of data (1 for each month). If I use the Month entity I get one column for each month of each year. My Year entity has 5 years, so I get 60 columns. Can the month name be extracted from…
-
Missing alignment of the legend in the cartesian chart
Hi Team, Initially, I have cartesian chart with single data block. Then the alignment is fine. Now due to requirement change I have to add another block despite it is hidden. The alignment of the names is not matching with the icons in the legend. Could anyone please help me to fix this issue. Thanks & Regards, Vanam Pavan…
-
Decimal points is being replaced by datareaders
Dear, Im facing an issue with the data readers whereby a value 37500.00 is being uploaded as 3750000 Grateful for guidance. Rgds
-
How to get last closed month desc
Hello I have a button on my screen where i can re-initialise data for opened months based on the last closed month data. So i have a button "re-initialise forecast months based on last month (display the lastmonth) actuals" In below example my laste month is Dec 24, im trying to a do a filter on block d, but block d is not…
-
Latest Value Per Month
I have a cube by Employee, Cost Center and Day. I would like to populate a cube which is by Employee, Cost Center and Month with the latest value (as close to the last day of the month as possible) for each Employee, Cost Center combination as shown by screenshot. Doing an extract reload unfortunately does not work as…
-
block algorythm (downtotal) incorrect
Hi all I would like the down total of Pot Displacment in a seperate column. Which i tried in column dt(h) however it gives me a different result i want to -63.098. any idea what is wrong? Thanks maik
-
How many unbalanced hierarchy maximum on a cube ?
Hello, I would like to knwo if there is any known limit on the number of Unbalanced Hierarchies that can be used in a cube and if the Board 15 Version changes something ? Thanks
-
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…
-
Dynamic File Name based on Entity Member.
Hi Guys, I am exporting a layout to the server, and I need the output file name to be dynamic based on the selected entity member in the procedure. For example: If the Data Category is Entity and the selected member is Actuals, The generated file name should be: Actuals_Report.csv Could anyone guide me on how to achieve…
-
Chart preview behaviour in layout editor
Hi everyone, We are observing a behavior in the layout editor where the automatic update does not take effect in the chart preview. This occurs when changes are made in the data block or under “Filter and Sort,” and can be reproduced in various configurations and screens. Is this behavior already known, or is there a…
-
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
-
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
