-
Dynamically select the Last 12 months based on the Pager value
Hello, I am trying to find a way to select dynamically the LTM for a bar graph in a screen that has a Month pager. I created LTM Flag cubes and a procedure based on the example made by @Sudeep Palkar and modified it to work with months but no success. Please how can I make the procedure that sets the flag work? I am…
-
NEXEL + CROSSVIEW + COUNTIF not working?
Hi all, On the row "0" of the second layout, I tried a deepest entity formula Nexel: =COUNTIF([#Data;@a;*;Range.Vertical],"=A") but can't make it count how many "A" lies on the first layout. I've also tried: =COUNTIF([#Data;@a;*;Range.Vertical],"A") =COUNTIF([#Data;@a;*;*;Range.Vertical],"A") And many others, but can't…
-
Conditional Formatting on Bar Graph
Hello, I may have missed something here but is it possible to apply conditional formatting on a Bar Cartesian so that all bars that have positive values will be green and negative values red? As of now, I can only format the graph background by using the Color Alert, and Visible and color blocks in Object Settings.
-
Rest API - Post-Call
Hi, we are currently exploring the REST API and the process of using the POST method to push data to board. While we have figured out how to use the POST method to initiate a procedure (by making a GET call to retrieve the data), we are specifically looking for a way to directly post data to the board. Is there a way to…
-
Board starts in a loop after login with Board v14
I just installed Board v14, and when I open Board it pops up the log in screen, after entering my credentials it stars in a loop that never ends, if I downgrade to v12.6 everything turns to normal, any thoughts about it?
-
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
-
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.
-
BEAM - Outlier Cube not populating
Hello, For some reason the outlier cube is not populated with I run forecasting. Other output cubes are populated just fine. I introduced a significantly large value so it should clearly identify it as an outlier. However, It does not populate the outlier cube. The structure of my outlier cube is in line with the actuals…
-
CLOUD DATA PIPELINE PORTAL
Dear , I am asked to use provided credentials on first login to the CLOUD DATA PIPELINE PORTAL. However when using the credentials shown on the screen, the login fails. Even using my board credentials , authentication fails Any idea please Rgds
-
Top n, Others, and Total in Data View
Hello, How can I display the following in a data view: Top 5 Clients with its total which is "Top 5" Total of the remaining clients in the "Others" Lastly, the Overall Total in "Total Revenue" I think I can do this by having 3 separate data views (Top 5, Others showing Totals only, and then Total Revenue also showing…
-
Edit Max Item Number
Hello, I noticed that it is not always possible to edit the Max Item Number of an entity. In which cases the max item number is locked ? Is there a way to change this behaviour ? Thanks for your help. Ian
-
Can we make one entity Parent of 2 Child Entities
I have a Use Case where I must show totals as KPIs for a few Data Points. The Data Points are at an intersection of 2 Entities - non-related to each other If I use these cubes directly to show the KPI, the KPI Value changes by changing the page's selectors. I was trying to bypass this by creating an entity that is the…
-
Change the TOTAL text in Data View
Hello, Is it possible to change the TOTAL text in the row and column header to something like "Top 8" and "Year Total"?
-
Data Flow calculation to total
Hi all, when i have a Data Flow setup in the procedure it does the calculation for the entities but not on the Total Level. How can that be done calculated (not average) on the total line, too? Thanks Maik
-
Vertical % Not on Grand Total
Hi, is there a way to show the Vertical % in Data Views as well for grand totals? (FC REV MIX in my data view) I can see it by column
-
Multiple "Detailed by" in Data view
Is it possible to use two ore more "detailed by" in an data view? It would like to report not only the average revenue / gross add per month by tarifcluster but by tarifcluster and a second or third entity.
-
Paste Data view setup without overriding what is already in?
Hi, Is there a way to paste a data view setup without overriding what is already in?
-
Order with detailed by Selection
Hi there, In a data view i have 2 cubes and right after it a algorithm. All are detailed by an Entity. In the display of the report I can see by status RN / REV for the first status and then comes the next status. However the ADR is shown at the end not grouped into the statuses as with RN and REV. Any idea how to show RN…
-
How to autofit/autosize column width to width of object?
I have a simple dataview object where the size of the table itself is not as wide as the dataview object. Is there a configuration setting to autofit the column width/table width to the width of the data view objects?
-
Board Cloud Logs: Service Status / Shared Storage Capacity
Dear Community, Wishing you a New Year filled with joy and fun! I would like to know the location of the SharedStorageZ file in order to retrieve the current capacity of the Shared Storage ( Possible to get this info using an API call ?). Is there any possibility to check via an API whether the Board Service is on or off?…
-
Layout in Excel Addin
Hello, Can we disable the layout in Excel Add in in order for the user not to modify it. does it have any impact if the user changes the layout on the excel. Thanks
-
Sap Analytic Cloud data import suggestion
hi, client migrated old bw database into a new sac platform. wondering if is possible in board14 to read data from SAC using other interface instead of the old theobald sap connector. any similar experience/suggestion to share? API? thanks
-
Week display in Gantt Chart
Hi, i am worling with a Gantt Chart and i was wondering why the weeks in the columns are displayed like 11/03 - 17/03 and next week like 18/03 - 24/03 in 2025 meaning always from tuesday to monday. How can i change this that it shows monday to sunday like 10/03 - 16/03? Is there a kind of setting? Kind Regards
-
Unhandled Error Message
Hello everyone, I have a SQL data reader(SQL-DR) that Runs with no issues. However, when I want to Edit the SQL-DR, board returns this error message. An unhandled error occurred (cod_ref: 1736282661225) I have done some troubleshooting but issue persist. This link took me to similar issues from previous years. My error…
-
Excel Addin
Hello, Im usingthe Excel Add in feature to create layout. However, how do we flatten the layout. In board we have the option, but in excel add in , is there any work around please. Also is there any security option on the excel add in to prevent the user from changing the layout? Thank you Rgds
-
Cannot insert Member - Time Entities
Hi everyone, happy new year. Can i ask why i am not able to insert members to an additional time entity> thanks maik
-
Entity Creation best practice
Hello Team, We are faced with an issue whereby we have multiple entities in a hierarchy. Now the screen using these entities will not load unless we restrict data from the higher level entity to one selection only. Meaning by default the screen is set to one Brand for example. What is the best practice when creating…
-
Total in flex grid
Is there a way to add a total or grand total row in flex grid? I have been tryin to add a total row but unable to see any such option
-
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
