-
Is there a way to have rows with no data not displayed in a drill down screen?
When drilling down through data on a report, I would like to be able to make it more concise by not having rows with no data be hidden. The below highlighted rows are examples of what I'd like to not be shown.
-
Data Flow with Change of Entity Element
Hello :) I want to make a DataFlow that shifts the value from one Element to another (in the same Cube) e.g.: Test_Entity: element1, element2 before DataFlow: cube: element1: 0 element2: 10 after DataFlow: cube: element1: 10 element2: 0 Thank you Kind regards wolfgang
-
Some Problems with BEAM
Hello, I have some questions to anybody, who has already some experience with BEAM. In order to get some practical knowledge about BEAM, I am trying to produce a model forecasting a time series with sales data, but the results are useless, as the model writes the same forecasted value in every future time entity. The value…
-
Import a Budget from Board into Xero
Hi, has anyone come across a need to import budget data from Board into Xero? I know Xero can upload flat files, but can it alos automated the proces with a api? Thanks, Tony
-
Totals on top of a stacked cartesian?
Hi, Our customer would like to see the totals on top of the bars of their cartesian charts. How can I show this for them? Thank you, Krisztina
-
Saving Time Function Forecast in a cube
Hi everyone. I'm interested in using the Forecast function in a cube that contains information about the sales amount until the past month, in order to obtain a prediction for the following ones. Currently I'm applying this Forecast function inside a dataview, the problem is that it takes too long to load the page. Is it…
-
Server command - Batchfiles not visible
Hello Together, i like to use server command to run a batchfile. I inserted a batchfile in C:/Board/Job, but it's not visible. Is there some configuration needed? Thanks for your Help!
-
Dataflows : c=a*b versus c=join(a*b)
Hi everyone, I see in an application developed by consultants here, that some dataflows are using a c=join(a*b) formula, and I can't find the difference with "c=a*b" when I test on my dataflows. In some cases, "JOIN" appears in the db log as the algorithm, and some other time it's HBMP. Does anyone knows what is the…
-
Need installation file 10.6.3.41077
Hi, i need this installation version to work with a client. Could someone send it to me as soon as possible? Thansk
-
Rolap cubes and writeback data from Board cube to SAP/4 HANA database
Hello, i will discuss several points around Rolap cubes here Documentation example for SAP/4 HANA relational table including writeback my questions regarding writeback to relational database Documentation (Board manual) I found only partial information in the board manual regarding RDB cubes and writeback topics in the…
-
D365 F&O Board Integration Configuration
Hi All, We are in the process of implementing Microsoft Dynamics 365 Finance & Operations (F&O) as our group ERP and as a result need to setup an integration with Board. Our Microsoft partners have suggested a few options. It would be good to hear if anyone else uses this as their ERP with Board and has any advice on…
-
Potentially corrupting a cube
Hi everybody, asking this question on behalf of a parter. They are removing contracts from a cube in a customers environment and carried out the following steps Took backup of cubes Took backup of tree for contract (ensuring it was well formed) Cleared all contracts Reloaded the tree (after removing the contracts not…
-
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…
-
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…
-
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…
-
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
-
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?!
-
Experiences upgrading from Board 10.x to Board 12.x
Hi Everyone, I'm relatively new to board and as luck would have it, my first project is to upgrade one of our clients from version 10.6 to version 12.2, with more clients to follow for the remainder of the year. I've read the instructions for upgrading and regression testing, however I am interested to get people's…
-
Collect and invite marketing data
We need a way to collect data from different platforms to load into Board. Fivetran would be a good option, but there is no Board Connector. Mainly it is about marketing data. What do we pay for advertising for etc? Does anyone have experience on this. An alternative would also be helpful.
-
Extract cube/file to local path
The question below relate to a cloud installation of Board (v 12.4) Is it possible with a procedure (Extract cube) to write the file to a path locally on the user's computer. Shouldn't write the file to Azure Storage.
