-
IDP | Users | Export - the Last Login and Account Status are not included
When I export the list of users from the IDP, I get a nice CSV file. But the columns Last Login and Account Status are missing. Why? Can these please be included. For analysis of users and their activity, this information would be very useful. Or am I missing something? ------------------------------ Michael Gerrard UNHCR…
-
Board MS-Office Add-In
Hello everyone, I just have a simple question, but actually haven't found anything about it here in the community. Does Board's MS Office add-in also work with Microsoft Office Professional 2021? Does anyone already have this in use in this constellation?
-
Subtotal
Hi How to Show Subtotal on table. ------------------------------ Shakti Dubey IT HARBINGER ANALYTICAL CONSULTING PRIVATE LIMITED India ------------------------------
-
Winter Release 21
Hello everyone, has anyone migrated (from 12.1) to the new winter release (12.2) yet? I am very curious about your experiences here... Best regards, ------------------------------ Dominik ------------------------------
-
Unbalanced Hierarchy in formatted report
Hi experts, I would like to know how have you all used unbalanced hierarchy in the reports? I have a P&L structure which I define as an unbalanced hierarchy in an entity. This works fine and shows the correct roll-up. the problem arises when I use this unbalanced hierarchy in a report * In the report, the parents should be…
-
Unbalanced Hierarchy in formatted report
Hi experts, I would like to know how have you all used unbalanced hierarchy in the reports? I have a P&L structure which I define as an unbalanced hierarchy in an entity. This works fine and shows the correct roll-up. the problem arises when I use this unbalanced hierarchy in a report * In the report, the parents should be…
-
Series Color Issue
Hello, I have been running into trouble when trying to set the color of a series on a bar chart. When I select the series and change the color, it applies the same color to all of the series. Has anyone run into this issue and found a solution? Thanks, ------------------------------ Matthew Sobon Data Analyst M.T. Maritime…
-
Recording of H&M Retail Store Workforce Planning Webinar.
Hi, I missed the H&M Retail Store Workforce Planning Webinar that was scheduled yesterday. If this webinar was recorded, could it be feasible to forward a link to the recorded webinar. ------------------------------ Vincent Dsouza Business Intelligence System Analyst Victorian Order Of Nurses For Canada Canada…
-
How to show total using Rows & columns
Hi, We want to know how to show only total columns using Rows & columns function from top left of screen. Table data have budget and actual. Green cell is actual, the white one is budget. When we use Rows & columns function for table of half year or quarter, the total value shows wrong. Specifically, when data has one type…
-
Pattern Based Allocation Problem
Hello everyone, I got an issue with Board 12.2 with the Pattern Based Allocation feature. Actually I'm trying to input a Forecast value based on the Actual's allocation. When I try to put a value and click on "Pattern Based Allocation", it does nothing! Before : After : And that knowing that I did the right configuration…
-
Lock down Total & enter Data
Hello Guys, Would like to know if there is a way to display two axes on the rows of a Dataview and enabling Data entry. The idea is to be able to change the repartion of the displayed cube without impacting the DownTotal ( but we may impact the subtotals to adjust ) The business Idea : changing Qty in order to lower the…
-
Locked by on row totals is always applied
Hello, We have one cube, with the month by column and with a "total row". It is in Data Entry mode with a "locked by". This locked by is conditional to a workflow cube: If the current process is validated, then the detail and total must be locked, otherwise the detail and total can be entered and we should be able to use…
-
Unbalance hierarchy : How to disable automatic entity member indentation in dataview ?
Hello, On dataview, is-it possible to disable automatic indentation (formatting) while keeping unbalanced hierarchy calculations active ? Any tips ? Because some unbalanced hierarchies have a lof of levels : World > Area > Country > Region > Activity > City > Shop > Department And for each level, Board is automatically…
-
Connection to SSAS DB (Tabular) from Board
Hi, Has anyone tried to connect to Microsoft SSAS DB (Tabular) from Board? If yes, please give your inputs on the same. Regards, Vikash ------------------------------ Vikash Gupta Consultant Board Community India ------------------------------
-
Average Down Total
Hello, I have run into an issue where Board seems to be ignoring the 0 values when calculating the down total when I have the summary set to "Average". Is this an issue with my data load?
-
Pager behaviour
Hello, Unless I'm doing it in a wrong way but it seems the pager behavior in Board V12 has changed compared to my previous version (V10). Example : For two interdependent pagers, the second pager in the v10 first highlights and sorts the entity members that belong to the selection of the first pager. Below this, the…
-
Running Total
How can I calculate a running total in Board? I want to see how our yearly sales are pacing against our yearly forecast. Jan 10 10 Feb 10 20 march 30 50 april 50 100 may 5 105 ------------------------------ Michael Hyder, MBA, CPIM Global VEG Control Tower Process Lead Bayer Crop Science LP United States…
-
iPad Optimization
Has anyone found any screen sizes, settings or tips/tricks that improve the user's experience on iPad's? Thank you, ------------------------------ Matthew Sobon Data Analyst M.T. Maritime Management (usa) LLC United States ------------------------------
-
Data Reader to Cube, can't find log file
another newbie question, thanks in advance for anyone that can assist !* I have several dimensions / entities + a flat file for a cube, in CSV file on AWS S3 * I am able to load the dimensions with no issue * I load the csv cube file, check the 'log' and 'stop on error' boxes * My log file is not in the same S3 bucket with…
-
YTD Selection Question
Hello, I am wondering if there is a way to have a specific month be selected whenever a year is selected. For example, if 2021 was selected the month would then select December 2021. This might be an obvious thing that I am missing. Thank you, ------------------------------ Matthew Sobon Data Analyst M.T. Maritime…
-
Not working "show all" at row settings
Hi there, I'm wondering if we can't use data view settings "detail by" and row settings "show all" at the same time. If I set "detail by", it shows all data(zero) although setting "show all" . I want to hide row having zero. Could anyone help me solve this? Kind regards, Marie ------------------------------ Marie Kawakami…
-
Best practices on Smart Import object & data control
Hi everyone, I'm doing some testing on the new summer release to evaluate how some new functionalities can help in our internal roadmap. In particular I've been testing the Smart Import object which will definitely help us solve some use cases. I have tested the following settings which seem fine :* Add or discard new…
-
Change Entity to Display Code
Hello, In a dataview, I would like for the @month entity to be displayed in it's code form. I do not see this as an option in the dataview settings but could be missing something. For example, when June is selected and the year 2022 is selected it is displayed as "Jun.22" but I would like its code, "202206", to display.…
-
Conversion from Time (text stored in Text cube) to number?
In Board 10 we used two text cubes for data entry for start and end times and cube with a nexel formula in the Data View to calculate the difference using value to convert from a time to a number. e.g. =value([@a;*;*])-value([@b;*;*]) While this displays properly in the data view, in Board 12 the result no longer gets…
-
Display Entity Description in Data View
Hello, I am attempting to apply logic in a data view only when specific Months are selected. When I use the Month entity in the data view, it displays the total number of months selected. I would like for it to display either the selected Month description (January, February, etc.) or the number associated with each…
-
Error Codes
Does anyone have a link to a page listing error codes with explanations? Does something like this exist? ------------------------------ Matthew Sobon Data Analyst M.T. Maritime Management (usa) LLC United States ------------------------------
-
BOARD R Calculation Step
At this point, BOARD's software includes an R calculation step. This supposedly allows users to run R scripts on data extracted from BOARD, then read the results back into BOARD. Unfortunately, the server package used to connect BOARD to R, Rserve, is known to have several IP connectivity issues when used on Windows. The…
-
Deleting entity members in Board 11
Hi Fellow community members, In Board 10, deleting entity members was/is against best practice. Has this changed in Board 11? I reckoned this might be the case since also the max item# property is not there anymore. If yes, is there a difference between a migrated database and a fresh Board 11 database? Thanks for your…
-
Procedure to Show Hidden Blocks
Hello, Does anyone know if it is possible to show hidden blocks through a procedure? Or something similar. Thank you, ------------------------------ Matthew Sobon Data Analyst M.T. Maritime Management (usa) LLC United States ------------------------------
-
Power BI Connector for Board | Login issue
Hi All, I want to ask if has anyone been successful to set up connectivity between Power BI and Board? I followed the steps as per the documentation. It states that we do not need any redirect URL when working with Power BI, but it doesn't show any login screen. It prompts me with the below error. I have tried clearing out…
