-
Percent of total
I've got a data view where I've broken down sales into several categories. How can I get the percentage of the total sales for each of these categories in an adjacent column?
-
Is it possible to change this reverse algorithm logic?
Hello everybody, I would like to know if you have any tip in order to “invert” the update logic behind this dataview and its reverse algorithm. In particular, I have 3 simple columns: Budget Value (a), Quantities sold (c) and Average Price (which is an algorithm a/c). Here the reverse algorithm for block b (avg price) is…
-
How to hide/ignore columns of an Excel data source when using the Smart Import Object
Is it possible to hide/ignore columns of an Excel data source if they are not relevant for the import when using the file upload of the Smart Import Object (e.g. descriptions or comments)? In the following table, columns A,B (entities) and D,E (values) have to be imported, columns C,F have to be ignored.
-
Use of Nexel
1. Abstract Nexel is a hugely powerful tool but it has its limitations, it’s important to understand when it’s appropriate to use Nexel and how best to store the original definition screen. 2. Context Use of Nexel can be hugely powerful, and in some cases necessary in order to achieve certain outcomes, however there are…
-
Managing high-volume entities
1. Abstract In complex environments, it happens to manage elements with a high volume. In such cases, it is crucial to identify the possible cascading effects on the rest of the model and what measures need to be taken when loading entities with millions of elements and evaluate in advance the possible impact on cubes,…
-
Insufficient privileges to manage this database
Hi, I am migrating a board 10 datamodel to a board 12 datamodel on a new server with an on-premise installation, I successfuly copied the database file to the board 12 database folder, I restarted the server, but when trying to upgrade the datamodel I get the following error " Insufficient privileges to manage this…
-
Temporary Cube vs Staging Cubes
1. Abstract When developers create a simple or complex procedure, they need to know that they have an advanced feature to ease their job by keeping the database simple and lean. This feature is the temporary Cubes. 2. Context Since B11’s introduction, developers can leverage the temporary Cube to store data temporarily and…
-
Divide by - Function
Hi there I have an strange issue: In the following i want to divide the values by 1000. But Board is actually dividing by 100.000:
-
How to compare the same days of a different year
Hello, I need to create a cartesian chart in order to show how much my company has sold this year and how much last year. The main problem is that we sell more on weekends, so if the first day of the year is satuarday, the year before it was friday, and it's obvious that this year performance is better than the last year's…
-
Cube definition insights
1. Abstract Insights on cubes definition and options. 2. Context The following best practices are applicable every time a new cube needs to be created in a data model. 3. Content Some limitations and constraints but also tips and guidelines from best practices and real-life cases. Cube’s dimensions can range from one to…
-
How to show the value of different dimensioned cube only in total line
Here is something I have implemented at a customer, and I would like to share with you. It may be helpful when facing a similiar use case. Use case One cube is on a dimension Article and cotains an Order Value The second cube is on Main Class, which is more aggregated than Article and contains a Limit for the Order Value…
-
Refer a colleague to the Advocacy Program and get points when they join (200 points)
Are you enjoying the Board Advocacy Program? We hope so! We encourage you to spread the experience and joy with your colleagues. For every colleague you invite to the program that successfully joins, you will receive 200 points. Steps for participation: Your colleague will email customer_marketing@board.com with the…
-
The Use of Tab Container
1. Abstract As soon as developers face screen creation, in particular, if we are talking about reports or BI Dashboards, where usually a lot of different data has to be shown, they need to use carefully the layouts to avoid any screen object overflow and, consequently, less impactful data meaning. 2. Context In the…
-
Multiple Cubes or Measure Entity
1. Abstract Using a measure as a dimension in a Cube should always be weighted based on the aim. The balance between the Cube size and Cube proliferation, how the measure will be shown in a layout, and any calculation between different measures. Board exploits a multidimensional and a multi-Cube database. When designing…
-
Data Load Guidelines
1. Abstract While developers are focused on data model creation and data integration, they need to remember that in addition to the data model structure, they have to fill this structure with data. Entities and Cubes have to be filled with meaningful data to be seen by the users. This document provides a standardized…
-
Data Transformation
1. Abstract The data transformation process can be done in three different ways: 1. with SQL transformations directly in the data source or in the Data Reader Object 2. with the out-of-the-box Board ETL function 3. after the data has been imported into Board by using the dataflow engine. The type and number of data sources…
-
Rule Consolidation
1. Abstract The rule is a key functionality that allows on-the-fly calculations between members of the same entity. The consolidation is a further step to physically store the result in the data model. This step is needed only in specific cases, usually when the calculated rows need to be reused as a source for following…
-
API Related Query
Hello everyone! I wanted to know, what is the maximum number of line items that can be transferred using an API. Can anyone provide information or point me in the right direction to find out more? Thank you.
-
Forecast Screen - Show total of an algorithm switching between two cube slices
Hi, I'm currently building a forecast screen. The requirements specify the following use case: the user selects a month and yeear months up to (excluding) the selected month show the actual value months including and after the selected year show the reference value (e.g. budget or estimate) In addition, the previous year's…
-
Bug : Selecting a member on a pager is not refreshing the screen (randomly)
Hi, Randomly, when our users are clicking on member inside a pager, Board is not launching screen refresh. Users are forced to select another member and go back to to targeted member. This error is occurs quite often (like 1 member selection on 10 member selection is not launching screen refresh) I have this issue for more…
-
Transfer data from Board to SAP BW
Hello I need to send some data from a Board db to SAP BW now we're implementing this through a flat files extraction (layout export) and consequent upload to BW. Is there any other (more direct and efficient) way? SAP Connector allows write-back? thanks
-
Use of Number Scaling
1. Abstract A common requirement when displaying data, particularly financial data, is to use scaling – whether that’s displaying numbers in thousands, millions or whatever makes sense in order to make the displayed data more easily readable. 2. Context There are multiple ways in which scaling can be introduced when…
-
Drilldown then export to Excel - how to work backwards?
When you drilldown on Board, then export to Excel, how do you restrospectively found out what you drilled down on? Effectively, the layout is filtered but the filter does not appear on the Sheet Selection, Workbook Selection, or Selection tab on the Layout. If you copy the layout back to Board, the hidden filter is still…
-
Copy Favorites from one server to another
Hi, we are updating our version and want to upgrade our server in the same step. What I would like to do, is to copy all settings (like favorites, presentations etc.), that the users have setup for themselves, to the new server. The users should basically not notice, that we have changed anything (except newer design, new…
-
What is an efficient way to calculate rolling average in a data flow?
Hi experts, I am reaching out to seek opinion on the most efficient way to calculate a rolling average based on current and prior months values in a data flow. Curious to know if using the time function period offset -1, -2, -3 etc. can be the only way to calculate this or if peope have found other ways that are maybe more…
-
What is the impact of switching a user from User(password) to User(Windows/LDAP/SAML) ?
Dear all, I'm wondering if any of you already has an experience with this kind of operation: Currently I have around 40% of my users which belong to a newly acquired company, where the Active Directory infrastructure is not merged with ours yet. To create them without waiting I had to create a specific password:…
-
Google Analytics in Board
Hi all, We are bringing into Board some very basic Google Analytics data via the Data Pipeline and SQL (Visit, Bounce, Transactions etc) just wondered if anybody else is bringing in GA data? Which prompts a couple of questions; * Are you doing the same way? * If yes, are you bringing in richer data than above and what does…
-
Alerts in DataView - Not available in vertical Alignment
Hi together, I have created a DataView and wanted do display an alert on the numbers. If the Block orientation is set to vertical, it does not show the alarm. Only if set to horizontal… WHY?!
-
Board Beyond 2023: It’s time to ignite the Intelligent Planning revolution
For the first time in three years, we’re bringing the Board community together in person to discuss all things planning. We’re beyond excited (😉) for a day of visionary speakers, sneak peeks at upcoming product enhancements, interactive solution sessions, and the networking opportunity of the year. Best of all, Board…
-
Relationship
1. Abstract Properly designing and maintaining relationships is essential for a well-functioning solution. In Board’s multi-dimensional database, relationships are a core component of the database configuration. Incorrectly configured relationships can make data partially or wholly inaccurate and lead to incorrect…