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.
-
Split a Yearly amount in Months according to Start Date and End Date
Dear All, 'Hope you're fine! I'm looking for splitting a full year amount between months according to a Start Date and End Date. For now, I identified 4 cubes: see below. All cubes have the 3 dimensions: Scenario / Company / Product Full Year amount (single: at Year level) Start Date (Date: at Year level) End Date (Date:…
-
Is anyone able to direct me to the Dynamics 365 documentation?
Hi all, I anticipate that I'll need to make use of the Dynamics 365 connector and the only documentation I've been able to find in the manual relates to this 2022 release: Is anyone able to direct me to the formal documentation? Ideally, I'd like something that covers the Board app for Dynamics 365. Cheers,
-
Cube visibilty lock failing when time function is applied to a cube in the same layout
Hi experts, Seeking your opinion and expert assistance with an issue related to applying time functions to a cube in the same layout where cube visibility is applied for data visibility restriction. If you use cube visibility function to lock a cube in the first picture below it works. However, If you then apply a time…
-
Possibility of calculating YTD figures based on MTD data using Rul
Hi All, I want to explore the possibilities of calculating YTD figures using MTD data using a rule. For example - Revenue for Jan 2023 - 1000 Revenue for Feb 2023 - 1000 Using Rule can we calculate and store it under new member called "YTD Revenue" YTD Revenue for Jan 2023 - 1000 YTD Revenue for Feb 2023 - 2000 Using…
-
Down Totals - What am I doing wrong?
Hello, What am I doing wrong here? In Block D, I want to display the Down Total from Block C. In the headers, I've written what Summary I'm using. In Block E, I just wanted to display what happens if I change the Summary to "Calculated".
-
Unbalanced Hierarchy - selecting descendants not available when "show only active members is ticked"
Hi, Has anyone come across on unbalanced hierarchies where if you have "Show only active members" selected in design mode, you then can't use the descendants option to select multiple members when you use the selector in play mode? I don't understand why you wouldn't be able to still select descendants on the list that's…
-
Detail By - Column Headers not showing
Hi all, I wonder if anyone has any experience with the detail by column names not appearing? In the example below I am detailing by this entity "Hub Source Stock Location" and the screen has 3/10 selected currently. In my dataview, I am able to view the 4 columns (which is correct, the 3 from the selection and a total…
-
Unbalanced Hierarchies - Entry on a Parent Level
Good morning, dear community, I'm seeking advice on a data entry challenge involving an unbalanced hierarchy. Is there a way to perform data entry at the parent level and propagate the values top-down to the leaves? Specifically, I want to apply an allocation percentage to all the leaves associated with "Parent 1." Here's…
-
Update Data changes Colours in carthesien objects
Hello everybody I have a week based report that is updated each tuesday with the previous week data. In the report itself it has a carthesien object showing the previous 7 weeks. The chosen Colour is "warm" (with yellow to red). Now when updateing the data and displaying the new week and the dismissing the week -8 the new…
-
Board time out duration
Is there a standard time out duration set in Board when a user leaves their browser open? if so, is there a way this can be amended?
-
Is there a simple way to rename a data model name (in bulk) in call procedures?
Hi all, I'm wondering if there is an easy solution to rename the data model name in call procedures in bulk. I've just read the best practice with regards to data model names, and it's to bad that during the implementation of BOARD (years ago) we didn't take this into account. While implementing BOARD, the consultant used…
-
Going to data model > cubes > structure is making IIS CPU load to 100% and super slow
Hello, We have this issue for a long time. Each time we are going to Data Model > Cubes > Structure our BOARD platform is instable / super slow because IIS CPU load start to increase to 100% and IIS memory also increase a lot. As a consequence, our PROD platform became super slow and unstable for users. Most of the time we…
-
Format Template - Mass font size assigment
I have a rather lengthy template - I want all rows to be the same font size, but it seems I have to click on each row individually. Am I missing a "select all" option? Thanks! Matt
-
👋 Fixing the article on OpenID for on premise
Hi @Board Community, @Board Support, Is it possible to correct the template openid.config at the end of the article in link bellow ? It's full of typos and not even valid xml (<add /></add>!) and apparently not the right redirect url path too. A ticket was open, but we are currently going by a trails and errors methodology…
-
Store SQL FileTable in to Board
Good morning: I saved a PDF in a SQL FileTable. Now I would like to read and write it from SQL to Board but I can't get it. I tried to upload the SQL FileTable mapping the differents fields but none of them succeeded. Could you confirm me if it is possible to send PDFs stored in a SQL FileTable to Board? As an example see…
-
Data Reader load 1st row only
Hi Board Platform, is there way to force a Data reader to load only the 1st row of a file?
-
Board integration with Monday.com
Just got a question from a Customer if Board integrates with Monday.com. I was wondering if any of you interacted with this software before and if we can connect directly, via DR to pull data in Board? I'd think APIs but unsure from their website
-
🚨 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…
-
Is there a way to transport Presentations from one server to another?
Hi, I'm trying to move presentations built in S3 to C2. The Data Model and Capsule has already been pushed to C2. How can I do the same for the Presentations? Or will I have to manually recreate these presentations?
-
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…
