-
Data entry on if-function with inverse algorithm
Hello, I have no values in the column HR (Forecast) in some months. I would like to pre-populate these cells with a small number (here, for example, 5) in a new column to enable the cells to be filled by manual data entry. I have used an If function to fill the column: h= if(g=0,5,g). How can I create an inverse algorithm…
-
Can we change data through dataflow using RDB cubes?
Hi All, Thanks for reading my message. I'm developing one dataflow, using RDB and MDB cubes, and I'm not able to change or update data into my RDB cubes. However, I can make changes using a direct data entry. Is it possible to use dataflow to delete, update or create rows into RDB cubes? Thank you.
-
B14: Adjust the DataView Layout Editor - Configure a drill on last block option missing
Hi @Product Management Team, I think it would be great if the possibility to configure a drill action on a block in a dataview was available on every block. The last block in a layout can't be configured due to the "preview" button which obscures this feature: Best, Helmut
-
Handling of .cfg Files in Text File Data Reader
In Board 12 & 14, the Text File Data Reader has a limitation in how it handles .cfg files when a pattern filter is used in the "Connection" tab. This impacts the automatic mapping of fields and the correct configuration of the file settings, such as delimiters, headers, and other parameters stored in the .cfg file. Issue…
-
Level 200, Module 207: Data Entry is not working
I am configuring Sale Planning worksheet within Module 207 task. I am adding a Dataview object for Cube BUD - DE - % Increase, and I put Data Entry option = ON, but after applying and saving the configuration, the fields are not coloured yellow, and Data Entry is not allowed in Play Mode. I would like to know, what…
-
I need help to configure my GCR Application
I have pasted the capsules and clicked on "Version#".Then I clicked on the reset application button in GCR Admin capsule.Now when i click on "import" none of my entity gets loaded.Can somebody share easy step by step guides for GCR configuration.I have been struggling for a month.
-
Filename substitution formula in Data Readers
Hello everyone, It could be useful for developers to have the following functionality implemented in Board: A new substitution formula @filename that returns the name of the file being loaded in the Data Reader. This formula could then be used in the ETL. Usage example: The client's cubes have the dimension "Month of…
-
ASCII Flat File DataReader - Move data file after reading
Dear all, I really appreciated the new "Delete file after reading" checkbox in procedures. I guess that, like most of you, our customer(s) require to move the flat file from its folder to another folder after its data was integrated into Board. However, most of the time, keeping the file in order to control the data loaded…
-
Substitution formulas in Data Reader path
Hello everyone, It could be useful for developers to have the following functionality implemented in Board: Have already existing substitution formulas recognized on the path field of Data Readers. Usage example: By using @database on the Data Reader's path, when duplicating a database, and renaming it, we wouldn't have to…
-
ASCII Data Reader - Load first/last rows
Hello everyone, It could be useful for developers to have the following functionality implemented in Board: Add a new setting on the Data Reader "properties" tab that allows developers to specify a certain numer of rows to be loaded, and choosing wether to load the first or last X rows of the file, and ignore the rest of…
-
Database security: Cube visibility
In the "Database Security" section, we have noticed that if we use cube visibility to define user action perimeters, it works everywhere except in dataflows. This behavior, despite being documented in the manual, seems quite illogical because if the functionality helps in profiling security profiles in a faster and more…
-
Procedure steps improvements
We would like to request certain improvements to the "Edit procedure" screen, to have a greater level of detail about each step's configuration and the overall view of the screen. New detail for procedure steps: The "Detail" column in the edit procedure screen shows information regarding certain configurations made inside…
-
Grand Total Group by format
Hello, It would be helpful if we could, in a layout, change the format Color and Font) of the Grand Total Group by. For now, it is not possible to identify easily the line (see capture attached) when the groups are collapsed. Thanks
-
Edit Row Format/Template on Drill Down Window
When configuring a drill-down pop up window, a developer can pre-configure an entirely different layout with a filter applied from the drilled-into row. In our case, we have configured a pop-up to enter comments, saving space within the data entry view. However, when we drill into a member with a Row Template applied,…
-
Quality of life improvements for charts
Pretty sure there are some more points to improve within the chart component but here are 3 proposals to add, as we often see them as requirements in our projects. While it is possible to achieve the desired results with the existing toolset, it could be easier to implement and therefore also easier to explain to customer…
-
Dynamic Replenishment Model: Key Calculations & Formulas
1. Abstract Retail replenishment is the process of counting the inventory you have left in stock and reordering the right amount of stock at the right time. In other words, it's the process of ensuring that you always have sufficient inventory in store to meet customer demand. 2. Content As part of the standard Board…
-
Select a row template per block to overwrite the row header template
Dear all, It's usual to have a row header format and a column format (for data) that are different. It would be nice to be able to apply to Blocks another format / template than the row headers.
-
metadata-driven modeling with BAML (Board Application Markup Language)
This feature is inspired by BIML (Business Intelligence Markup Language). To develop a board-application you don’t need coding skills. That is really great for beginners! To develop a board-application is mostly to create or alter meta-data. For example create a new entity. Give them a name, group, id length, desc length…
-
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…
-
👋 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…
-
An uploaded zip file - when the user downloads it, how can we control what the filename will be?
A user can upload a zip file to Board. When they do that, the original filename is lost. The new file name is generated how? Can this be controlled? For example, could the zip file have a reference number derived from where it was uploaded in Board? ------------------------------ Michael Gerrard UNHCR http://www.unhcr.org…
-
New Time Function "Year End-" and "Year Start Value"
1. What is your idea? The Idea is, to have additional time functions to easily get the values for year end and year start, also for previos years. 2. What specific problem are you trying to find a solution to, or what new scenario would this idea respond to? Independent from the current time selection, I want to display…
-
How to set up a 4-4-5 calendar
1. Abstract Board offers the possibility to create custom time entities in addition to the standard time entities to customize the calendar to specific business needs. Our goal will be to build a retail calendar based on the scheme of a 4-4-5 quarter, which is a method of managing accounting periods, mainly adopted by some…
-
Anyone using version / code management software in BOARD projects?
Hey community, I just saw Bob Gill linking his article World Cup 2018 to a repository on GitHub (GitHub - grobertgill/Tournament: BOARD Tournament model setup for World Cup 2018 ). This is something I have been thinking about now and then but have never tried to do. Is anyone of you using such solutions (GitHub, Subersion,…