-
Flex Grid filtering then exporting
I have a flex grid that I'm trying to export a subset of the data. So I go to one of the columns and filter it. When I then go to export it to Excel, it exports, but there is no data in the Excel file. No matter what column I filter on or what I choose, it exports an Excel file with the correct column headers, but no data.…
-
Security Settings do not apply with "Refer to"
Hi everybody, in our Board 14.1 (0.1.244711) we have a cost center dimension, that is used for the database security. The cost center dimension aggregates to three different hierarchies (legal entity, business unit and technology). Furthermore, we have a dimension for P&L lines. We have created a dataview which has the P&L…
-
Formatting data in hierarchy
Hi, I need help to do a formatting. I have an hierarchy like this - Red box is Level 1 (Parent),Green box is Level 2 (Parent) and Blue box is Level 3 (child). Level 3(lowest child) ← Level 2 ← Level 1 Is there a way by which I can format this hierarchy on screen…such that level 1 appears in font size bigger that level 2…
-
How to disable on Alert formatting on Total row
Hi BOARD Team, I applied COLOR ALERT on a data block. It works fine on each row. However, it is impacting the number showing in the row total. Anyway I can force the row total as BLACK? Thanks
-
Move file to archive directory
Dear, Is it possible to move a file after it has been read by a datareader to an archive folder. Is there a command that can be used in procedure to execute a copy command etc. Thank you
-
Are exclusions of certain characters possible while entering text data ?
Is it possible to exclude certain characters, spaces, enter etc. when entering text data in board? E.G. Data Entry for a space " " is forbidden.
-
Board data entry
Good evening, I am trying to create a budget report that allows users to edit values through data entry. The following table presents the data in the following order: Months in rows (entity) Sales from the previous year (cube) Budget for the current year (cube with data entry enabled) Sales for the current year (cube) As…
-
How to reset pager to default name
Hi everyone, I'm looking for a way to lock my Pager 2 to its default state "All" when I enter my screen and select any options in Pager 1. Currently, when I select the "TRS" option in Pager 1, Pager 2 automatically switches to "TRS" as well. This happens because Pager 2 is set as the parent of Pager 1 as shown in the…
-
Basic question about data security
I have a question about the security concept. Within a capsule, I have two folders: Folder A contains data that should not be filtered by an entity, while Folder B should be filtered by the entity 'Team.' Is it correct that there is no way to implement such a requirement in Board? My only solution at the moment is that I…
-
Time zone to be factored into Date and Time outputs
We have users in different time zones and we would like for Date and Time to also include an output listing time zone abbreviation. We have attempted to set the culture code then use "@datetime" in our report header. This gives us the date with the word "time" written after it. We have also used "@Date @Time" which…
-
Capsule Snapshot "restore"
Hello everyone and happy Monday, I took a capsule snapshot, uploaded the snapshot in my Dev environment. Now, I'm looking for ways to 'restore' or 'open' this snapshot in a newly created capsule. So far I have not been able to find an article that explains how to do this. Is this doable in board?. Thanks Walter
-
Can you Procedurally Export to Excel?
We have a budget cube that is loaded to via the smart import object. After a bit of transformation on our end, we want our users to have the ability to export this data in xlsx format (same format they initially loaded to in the smart import object) for their own purposes. We would like for there to be an interactive…
-
Suggested value in excel add-in
Is it possible to display suggested value in excel add-in? This is required because it has been observed that although the suggested value is on in dataview but as the user tries to upload data excel add-in even values outside suggested value gets accepted.
-
Expanding a column for a drilled Data View
Hi all, after drilling in the main Data View, I'm left with another Data View that has an "collapsed" column (screenshots below) If i manually expand the column and then save, once i go out the layout the column remain half hidden. I don't seem to find any option in the settings to expand the first column. How can i make…
-
how to use IRR
I want to use the IRR and NPV function in Dataview, but the help is not clear for me. Syntax: IRR(arrayvals,estimate) This function returns the internal rate of return for a series of cash flows represented by the numbers in an array But my question is : what does mean Arrayvals ?. I created a dataview whit a cube "a", and…
-
@datetime not working
Dear, In below algorithm, @datetime returns invalid algorithm any idea abt this issue Thank you
-
Procedure "Backup data model" - automatically delete files after Expiration days
Hello all, we have a procedure step "Backup data model". In the settings we setup 7 days for "Expiration days". The backups are also successfully written to the corresponding directory. The backup files are not automatically deleted after 7 days. Our Board Version is 14.2.1.1.282551. Has someone an idea? Kind regard S.…
-
Labels
Hi, just a short question, how can I use a label to show the DataModel entity "Users"? If I set @Users I get the system User with and S at the end. BR
-
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…
-
Top, Mid, and Bottom Clients in Waterfall Chart
Hello, Is there a way to show the Top N clients, all clients in the middle, and Bottom N clients in a Waterfall chart? I can either show Top N or Bottom N clients but not both at the same time and also I am still missing the Mid-range
-
Is there another way of applying rules to an algorithm in layout configuration ?
-
XIRR calculation
Hello, Does XIRR work with NEXEL? I cant seem to figure out a syntax that generates any results. Not getting any error message or anything. Thanks,
-
Dynamic Color Alert
Hi All, I am seeking a solution for an issue I am currently facing. Specifically, I require a dynamic color alert, but it appears that I need to select the number to link to the color. Unfortunately, I am unsure of the maximum number that should be used. Kind regards, Andrea
-
Export Data to excel
Hi , when exporting an entire screen to excel. How is the order of the data views = worksheets determined?
-
Substitution Formulas
Morning, quick question I have a substitution formula in a dataview Selected is 31/01/2025 however it is showing today's date. How can I see the selected date?
-
Dynamic Visibility of Data Blocks (Hide When No Data is Present)?
I have a data view object that is storing 5 different report types in 5 different cubes. The rows are dimensioned by fiscal year and month and there is no dimension on column, meaning that the 5 columns are the 5 data blocks in the layout. I would like to hide data blocks (Legal Income Statement & Legal Balance Sheet in…
-
Can you highlight or show a marked value for a specific month in a bullet chart ?
Similar to this visual:
-
Data Entry with filters
Hi, In a dataview, there is one data-entry block, which is a cube with dimension by A and B. I need to have A on the row and B on the column. However, I need to show only specific members on B (Which I already flag by using another cube) Is there anyway I can do that as the filter on that flag cube does not work; the data…
-
Direct Links Don't Work When Capsule is set to "Hide Screen List"?
Our platform team made the decision to turn on "Hide Screen List" for some of our more common capsules, specifically to avoid inundating our users with reports that they don't need to be bothered with, amongst other things. However, whenever I try to send the direct link for a report to a user, it launches the home page of…
-
Cubes
Let's suppose I have a cube with dimensions month, scenario, version, competency and another cube with dimensions month, scenario, version, los, location. The end cube in which I am storing the value also has location at it's dimension. LOS and competency entities are in relation LOS being the parent and competency being…
