Platform Q&A
This forum is dedicated to Board platform questions, generally applicable to all members.
Please select 'Yes' if a response answers your question to better identify possible resolutions.
-
Weekwise and Monthwise data entry in same cube
Can we enable a cube to allow monthwise and weekwise data entry ?
-
Datareader - SQL Connection
Hi All! We are currently implementing a new Data Warehouse with a direct connection to Board. Now, my problem is that the DataReader does not always show the available tables and views from the Data Warehouse. Within the Cloud Portal, I have set up the access correctly, and the test was successful. Sometimes, it works—I…
-
Default relationships (missing parent)
"Default button" to fix the missing relationships: is it a one-time solution for members to "missing parent" at the moment or can you use that function as a default automatically for new members that have a missing parent?
-
Selection on screen
Hi everyone, I need to display data for different months on my screen. Specifically, I want the current month to be selected in the screen selection, and I also need a graph that shows data for the 12 months prior to the current month. Can anyone guide me on how to achieve this?
-
Database security profile lock out
I had a data model that I didn't have any database security profiles on and could work on. I needed to add some security to it so I first created an admin profile for myself with the following parameters: Access Mode: Database Administrator Security System: Builder Security Filters: None I named it ADMIN as that's what…
-
Importing Data from PowerBI Dataset
Hello, has someone an idea or experience in importing Data from a PowerBI Dataset as Data Source? Best regards
-
ALM Transport from Development to Production
I've used the Data Model and Capsule snapshots and transport packages in the past without any issues. However, I'm having an issue with one where our development environment (14.1.0.0.161052) is now on a different version than our production environment (14.1.0.1.240135). I created the data model package and moved it from…
-
Show All Text Cube Values for Each Entity Member
Hi all, Is it possible to show all text cube values for each specific entity member? I am trying to show all values from a text cube that are mapped against the accounts (See sample table below). When I try to use the text cube in the Layout, it's only showing one line of text when there should have been multiple lines. I…
-
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
-
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
-
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…
