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.
-
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
-
What is the purpose of "Position Changes" in the Data Model Transporter?
We recently executed a backup and restore of our core data model from production to non-production. Everything was aligned momentarily; However, as soon as we developed a couple new objects (cubes, rules, entity formats), the data model comparison tool exploded to show several hundred changes between environments. Of the…
-
Skipped rows of Cube value of 0
Hi guys, I have some issues that have skipped rows of Cube value of 0 but in Data Reader ETL is displayed well. I have unchecked Hide zeros and checked differentiate zero and null. Anyone have some ideas or solutions about this one? Thanks previously
-
Suggested value in Excel Add-in
Hi ! Is it possible to show suggested value feature to user when using excel add in ? Also can I put data validation check in excel add in?
-
Blob Cubes (Custom) Upload and Download Functionality
I'm creating a screen within our business planning capsule that will be a single data view object intended to store various file types that offer supplemental information over what's provided in the business plan. I would like for the file inputs to be heterogenous, so that I don't have to create a cube specific to the…
-
Entity member sorting
In configure layout of data-view, I have taken cubes with required dimension and the entity on which I want to apply filtering and sorting. For sorting, I am using the algorithm -…
-
Hover-over cards not appearing on Bubble Chart object in B14
Hi, We've recently migrated a reporting capsule to B14 from B12 and it's come to our attention that hovering over bubbles in the Bubble Chart object, no longer brings up the card which details the values of the block. Has anyone else experienced this? Is there a setting I now need to toggle on, or is this a bug? Cheers!
-
Delete entity member through entity editor object
Hello, Is it possible to delete an entity member when using the entity editor. The documentation says CRUD operations are allowed once ATO is enabled, however i cannot see the option to delete. Thanks
-
Selecting Months for Single Month & Multiple Month graphics
I am trying to set up a screen that uses a single month selection for a waterfall chart and multiple months for a graph of monthly figures. I have managed to get a procedure that selects the last twelve months, however I could not use this selection alongside the waterfall chart. I have tried using a custom time entity but…
-
Column Entity Always Show the Total Members and Not Display the Actual Value in Dataview
I want to know the causes of why my Part Number column entity always show the total members and not display the actual value? Did I have some mistakes in mapping my cubes? FYI : Cube (Mixing Ratio)→ Have 3 entities mapped into it (Part Number, Plant FG, Supplier/Cost Center) And here captures of my settings in Layout…
-
Selectors - Active Selection
Hi, We have a Selector on a screen which shows the Active Counter and Active Percentage. The entity of this selector is previously prefiltered by a On Open Trigger procedure. This makes it display 20/50 elements even if the user has not Selected anything. From the user point of view, he/she should only see 20 elements. And…
-
Block showing only sum total
Hi everyone, Is it possible for a block in data view to only display the sum total? I've tried using the algorithm rt(j) but the variance total is incorrect, i.e. I want the total variance to be -7,425.5k, not 325,424.6k. If I take away 'Detail by Month' in block j, the variance calculation is wrong. In essence, how can I…
-
Run an SqL data reader on the current selection
Hello, I'm running a data reader from a procedure with the YEAR (called Année) selection. I would like to scope the data based on the current year (selected when the data reader is run). Below the SqL command. I guess I should write something in the "Where" section. I tried with @Année which did not work. Thank you very…
-
Cleaning data in Data Reader with exclusion rules
Hi everyone, I'm currently working with the Data Reader in the Board Platform and I need some help with cleansing rules. I would like to exclude certain rows from being loaded into the entity based on specific conditions. For example, I want to prevent any record where a value starts with "5HR014" from being loaded into…
-
How to find maximum value of cube or entity in Layout Editor?
Hi guys, I have no idea about how to find maximum value or calculate this formula inside Layout Editor Dataview : "Max of Price In IDR (Current Month) = MAX(Price In IDR) WHERE BOM Period = Current Month" I will appreciate your helps for this case. Thanks.
-
Board call API using OAuth 2.0
Hi Community, I want to create a Board "Data Source" connector to Google Drive API using OAuth 2.0 authentication. I have created an id application on Google Dev/Cloud. But I am not sure about the Board Callback URL section. For now, I use url callback: https://my-domain-name/en/Callback.html. When I create a Data Source…
-
Adding Blank Rows that Mesh with Block Format
Hello! I'm working to enhance our current P&L report to improve vertical readability. I'm doing this by adding "Blank" members to the entity used in the by row configuration underneath key metric milestones (ex: Total Rev, Total COS, GP, etc.) No problems there; However, the formatting is clashing with block format since…
-
Example of the new @ProcedureId Substitution Formula
Hi, In Board 14.3 there is a new substitution formula called @ProcedureID. Can someone give an example of how we can use this new substitution formula? thanks RJ
