-
Why am I unable to create a capsule and folder in the UI?
Somewhere along the way some security setting must have changed, but I am no longer able to create a folder or capsule from the UI or transport new folders or capsule from non-prod environments. It's strange, I'm able to add capsules/folders in our non-prod environment just not in production. I've checked all the role,…
-
Trigger a pipeline in Azure datafactory from a Board Procedure
Dear, I want to create a procedure in board which will trigger a pipeline in my azure datafactory. The pipeline in adf will trigger an extraction to the datawarehouse which will ingested by board. Has this ever been done is this possible? What steps should be carried out? Best regards, Mirko
-
Strange parts of my construction at Level 300
The numbers on the screen I constructed are incorrect. The values of PY Actual and CY on the Sales Planning Screen are the same. Which part of the structure or operation do you think is causing this? The dynamic year selection for SET Lock Planning and SET Unlock Planning, which are DM Procedures, is not working…
-
Data blocks heading to show up as Categories?
Hi there - this seems it should be very simple in my mind, but I can't figure out how to make it work. I want to have data block headings to show up as bar's titles in X categories: In the screenshot, you can see Jun.24 in X axis as having month entity set as category. I don't even need a month label; the entire screen is…
-
Three questions before a possible new project
Good morning, for a possible project I have a few questions in advance as to whether it can even be implemented with Board. Is it possible to add a signature field to the board, for example is signed digitally with a Signpad? Can you list the directory contents of a network drive and then display the PDFs in it in Board?…
-
Is it possible to put a variable in a URL on the label action "Go to Url"
Hi, I would like to know if it's possible to put a variable of an entity in an URL when performing the action "Go to URL" on a label. Example : we have the entity "Index" and we want to add the code of this entity at the end of an URL; The screen is filtered by one "Index". Regards
-
Lock data entry row total cell only
Hi BOARD team, I had a data entry table as following. Can I lock data entry for the row total only (allow data entry at the detailed level, but not the total)? Can I add a validation based on the TOTAL? When user make data entry at detailed level, the total must be added to 1, otherwise system pop up an alert and does not…
-
Suggested value in smart import
The smart import gives functionality to use suggested values. But these suggested values don’t work when I download and upload the template. As a result if I enter any data that is not in suggested value it still gets accepted. Kindly advice how can I resolve this issue.
-
message : "The requested database is currently being modified by another user"
Hello, I am experiencing an issue with my database on Board, and I would appreciate your guidance. The database I am using is well-structured and has been functioning as expected. Recently, I added a "Quarter" dimension to the data model. However, since making this change, I am unable to access or edit screens that rely on…
-
Sourcecode Control?
In traditional programming environments, sourcecode control is the ability to track all configuration items and code contributing to the application. Does BOARD have some way of interacting with sourcecode control? I understand it's more of a graphical development environment, but I know many formats are supported by…
-
cube visibility / grant cubes
Dear Team, Currently exploring the cube visibility / grant cubes at link below Cube visibility i have some difficulty understanding the grant cubes and how they are used and when they should be used. Do we need to create grant cubes and how many do we need to create and based on what. The link also speaks of an…
-
How to remove/hide lock symbol from totals
I have locked row totals of the cube and now I am getting lock symbol beside down totals as well as row totals. This is working as expected. Is there any way to hide/remove lock symbol from totals.
-
Filter on Dataflow
-
Query on File Management in BOARD with Azure SFTP Integration
Dear Team, I hope this message finds you well. I have received a specific requirement from the client regarding file management within our Azure storage environment. The requirement involves moving files from one folder to an archive folder in the SFTP directory under Azure storage. I would like to know: Is this…
-
date cube : data entry
Hello everyone, I am facing an issue related to the use of a date cube. In a layout, I have a date cube (structured with only 2 dimensions, including the year) open for input, which allows identifying the start of an allocation on a specific day. The default year displayed is the current year, but I would like to display…
-
Level 200 - MULTIPLE ENTITY SELECTORS
Hello everyone, I am working on a report and I'm required to have many SELECTORS on the screen. However, having too many selectors on the screen leaves me with very little room for the actual report(data view) and makes my screen look too crowded. Is it possible in board to configure a SELECTOR object such that it displays…
-
ADD NEW ITEM in datareader (transaction)
We use "add new item" in a data reader on an entity when we import transactions. When there is a new member in the entity, it is populated into the entity, which is as expected. The problem is that no data is loaded on this member, even though it is in the source we are reading from. Disc rec doesn't show anything…
-
Month Selection in the Drill To Screen
Hi BOARD Team, I created a drill to screen If I double click Jan.24 column in the graph, then it will take me to a new screen with the same selection. In the new screen, it will only show Jan.24 which is the same month as I drilled through. But I want to show two month before and two month after Jan.24 to provide some…
-
Can you calculate with an entity?
Hi, you can display entities in a Dataview, but can you also calculate a new value with these entities in an algorithm, as you do with cube values? We want to multiply a cube value and an entity value within a Dataview. Is this possible in an algorithm? Kind regards
-
Time function cannot be applied on Temporary cubes?
The yearly cummulative time function doesnt work on Temporary cube. Any idea why is it so? The goal is to calculate the YTD value where the source cube on which I am applying the formula is a temperory cube.
-
Deactivate the mouse over of the cartesian graphic of the category axis
Hello everybody, I would like to deactivate the mouse over in a Cartesian Bar graphic. I only found the possibility that the value of the Series won't be shown (deactivate the option Separator in the primary axis). Is it also possible to deactivate the category axis? Best wishes Thomas Schendl
-
Level 200 Module 204 Functional Test
I am stuck on the last functional test. My totals are 18, and not the 10 required. I have checked the relationships, data reader, deleted and re-loaded both cubes. I have no idea what I am doing wrong.
-
Migration to Board 14.1 - Difficulties I found
Hello Community, Lately, I worked on the migration of my main customer's application from Board 12.6 to Board 14.1. Naturally as in any migration, I ran into some issues I would like to share with you. I would also like to know if the rest of the community is also migrating to Board 14.1 and the eventual problems you…
-
Level 200 - ETL
Hello community, I need resources on how to use the ETL section of a Data Reader to effectively perform aggregation between two or more columns. Any resources that I can explore will be highly appreciated. Thanks and have a great Thanksgiving week.
-
How to see memory consumption of each DB on the server ?
Hello, On our local server, BoardEngine is using 30go of RAM and we have 15 DB How can I see how much memory space is allocated between each DB ? thanks julien
-
Flex Grid - Opening fully collapsed
Note - Ignore this, found the solution! Is there a way to configure the flex grid so when you load the screen it loads fully collapsed to enhance speed?
-
Flex Grid and wrap text in columns
Hallo everybody, in a Data View it is possible, to wrap the text in a column, so you can use a small columns width. Is this function also available in the new Flex grid object? Best wishes Thomas Schendl
-
AI Integration API with OpenAI
Hi community, To enable and empower my data with AI in board, I am looking for a step by step guide on how to set up an API with OpenAI to analyse my data with the big language model ChatGPT and get the text response in board (text cube). I know it's possible, but I haven't found a guide on the forum on how to set it up.…
-
How to get just the date in ETL on data reader
Hi, I'm trying to find a difference between a date when and item is released and today on my data reader. I have the release date pulling from an API source. I'm using the =today() formula to return a day on an ETL but it's pulling back the date and time stamp like this: Then when I subtract the two I get a really off…
-
Add Filter to a screen
Hi all, I have Screen1 and Screen2, in which i want to apply the same filter for Entity. Through a procedure I managed to apply the same filter (that we can call "Deal") to both Screen1 and Screen2, by selecting it from the Screen1. Keeping in mind that Screen2 is already filtered for "month", when i apply the filter…