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.
-
Question about Label
Hi all, I'm trying to figure out how to cancel the label's animation. I'm using the label to partially cover an image by adjusting its opacity, but whenever my cursor hovers over the label, it lights up based on the label's color. before and after do we have other Object to use it or some setting for the label? thanks 😀
-
Possible security profile issue with Board 14 on-prem installation, has anyone else experienced it?
Hi, We experienced an unexpected issue with our security profiles and the only thing we can connect it to is our installation of Board 14 onto our on-prem environment. Before filing a ticket with support, I wanted to reach out to the community, see if anyone else experienced it, if this is a known issue, etc. Basically,…
-
First and Last Purchase Date
Hi Board Community, I am trying to build a report to show the customers first purchase invoice date and last purchase invoice date. In SQL this would be a simple min/max on invoice date, however, am finding this doesn't work in Board. Any suggestions on how to build this report in Board?
-
End Date on a Day (as Start Date)
In the rows I have the day entity. In column 1 the possibility to enter a number of new hires and in column 2 the end date for the new hires. The date on which I enter the new hires should represent the start date. In a procedure, the number of new hires should now be written to the days from the start date to the end…
-
Cumulative Total On Ranking
In an object, how do I do a cumulative total on a ranking column? I'm trying to do an 80/20 analysis and to grab the top 80% of an entity but each row is just their % to total, not a cumulative %.
-
Procedure: Extend Calculation on new tuple for all members
We have a source cube (Input Cube) as shown below with dimensions highlighted: We have a target cube as shown below with its dimensions highlighted: How does "Extend calculation on new tuples for all members" affect when we are copying data from source to target cube? What happens if we select all/ any of the members and…
-
Account Set up
Hello Community! My boss/Board expert just left, and I have a simple question for your experts out there! Where can I go to see how an account is calculated in the P&L? Thank you for your help!
-
Data Reader Configuration From Local System
Hi Team, I attempted to configure the data reader to load a CSV file from my local system. However when i specify the file path, no files appear to be available or recognized by the system. Please advise if there are any prerequisite configuration or settings that needs to completed before this step? Thanks for your…
-
Drill Down
Hi all, is there a limit how far you can drill down? Thanks< maik
-
Question about dynamic selection with two parents of the same entity
Hi Community, I’d like to share a slightly complex use case that might open a discussion on potential improvements or clarifications around how dynamic selections work in Board. 🎯 Context: I have an entity called Month, which has two parents: Month of the Year → contains values like January, February, etc. Year Period →…
-
Interaction Block Format
Hi, I have a question regarding the Block format. I'm trying to add a symbol after the number, but it doesn't work properly when I use the algorithm in the layout editor For example the image below, for some reason it can't show the euro sign for every month but only for the null cell i hope you can help me thanks 😀
-
Efficient way to copy value in the Procedure
Hi all, I'm trying to improve my current Procedure i have a cube with 3 dim ( Drivers, Month, Type A or B) My goal is to copy the value from Driver 2 Type A → Driver 3 Type B as you can see in the image below My step is: 1) copy the original cube into a Temp cube 1 2) Clean the Temp cube 1 using the selection on Driver…
-
Interacting with a Dynawrite Object
Hi Everyone, does anybody know how to write on a dynawrite object on play mode?
-
How do i change the number format
Hi, I have a question regarding the format of the number in Board how do i change from the format of number from "," to "." → for example 25,000 to 25.000?
-
Dynamic Visibility of a cube / data block in a data view
Hi, is there any possibility to steer the visibility of a cube / data block in a data view? I want to achieve that I can steer on an admin scree, if a certain cube/data block is visible in a data view on another screen. I know that you can steer the dynamic visibility of the whole data view, but I need it for a certain…
-
Linear Programming Problems in Board
How can we solve Linear Programming Problems in Board - Nexel or Procedures or any other tool ? Example contribution maximisation with limited machine hours, what should be the product mix. In Excel we can solve this using solver addin.
-
How to Group Columns by Cube in Data View Layout
Hi everyone, I have question about data blocks Detail by Month As shown in the attached screenshots, the columns for Q Ovun (PO) and Q Ovun (GR) in the Data View are currently sorted by month, which results in an alternating pattern (e.g., Q Ovun (PO) Apr.25, Q Ovun (GR) Apr.25, Q Ovun (PO) May.25, Q Ovun (GR) May.25,…
-
Detail by On a block
Hello Team, I have a question regarding the Detail By option on Cubes in a dataview. Is the Detail By similar to a Group By. I see from the documentation the Detail By overrides the by column axes. Also, if we consider below documentation, why would i override country by Channel by using Detail By when i could only set By…
-
Loop function doesn't work
Hi all, I'm trying to do a loop calculation, but for some strange reason some of the numbers don't add up the cube has 2 dim (month and Drivers in blue) the first member of Drivers (baseline) has only the value in the first month, while for driver "a" "b" "c" i can data entry after the first month my goal is to copy the…
-
How to Change the Export Excel Column Header and Total column Color
Hi, Please guide me how to amend the color for column header and total column color. Thank you. Sin yee