-
Hint on calculation
Any ideas on how to do this type of calculation in a dataflow where C2 and D2 and so on are calculated from previous month from row 5. I can only get it to work if i calculated each month in a loop, but there must be another way?
-
Does B12.6 or following versions allow to refer to on descendants of an Unbalanced Hierarchy?
I'm currently working with B12.4 and we cannot select descendants for an unbalance hierachy in the refer to option of a block. Does anybody know if this has been fixed in B12.6 or subsequent versions?
-
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
-
Excel add-in data entry
Excel-add-inに他のExcelファイルで作成した複数の値をコピー＆ペーストしたいです。 Excel add-inに直接手入力を行うと背景色が緑色になり、保存を押下すると保存される認識です。 ですが他のExcelファイルで作成した値を複数コピー&ペーストすると値が消える+緑色セルにもならず、入力が正しく行えません。 他のExcelファイルから複数コピー＆ペーストすることは不可能なのでしょうか？
-
How can I calculate difference between two dates?
I want to calculate the difference in days, hours, minutes and seconds between two datetime stamps and I would be very interested to know how others have approached this. Currently I seem to be contemplating a solution which first subtracts one date from another to get a decimal. Then I would convert that decimal to days,…
-
Compare date in column algorithm
Dear All, I have 2 cube, the first cube is a date cube with one dimension is article, the second cube is single cube with 2 dimensions are Month and article. I want to make a new single cube with 2 dimensions are Month and article. i want to fill the value in new cube by second cube with the logic is if the month in second…
-
Connect Power Bi Connector to Local host
Hello, Is it possible to connect Power Bi with the local host server?
-
Start screen in Google with Board user and password
Hello all, we will start one screen in Board with a desktop shortcut. The problem is, that we must enter the Board user/password. Is there a way to pass on the board user and password? Kind regards Stefan
-
The Database size got reduced from 24 GB to 19 GB after extract and reload of the database
Recently i performed Max item number change for few entities and for that we extract all of the database and do this change and then reload the database. There is no loss of any data for me, nor there is any issue but the only thing i observed was after the reload of the database the size of database got reduced to 19 Gb.…
-
❓Follow-up with Security Filters and Refers "To"
A coupe of week ago, I post this (also ticket 00095180 ) However now that the 17 novembre patch fixed the issue we finally resume testing on the security again. While the patch improved on the situation we have one edge case that seems strange : when a user end up with no value in the entity Etablissement in his security…
-
Relationship changes logs
Hi Board Expects. Quick question: does any of the log files provide the details of relationship changes between entity members? A DB log shows the entity names and shows the record that the relationship was modified. Can we see anywhere the members of child and parent entities? Eg. we have Item → Item Category…
-
Impact analysis: Oops we are yet ready to analyze this Datamodel..
Hi all, After a restart of the service, i receive this message when i navigate to the impact analysis (never seen this before). Also, when looking at the analysis of my cubes, everything is 0. Is this normal? How can i solve this? I've been waiting for a while already.. Andries
-
Integration with R - Load data doesn't work properly
Hello, I experimented the following problem. After execution of R statements, the DataReader doesn't work properly, but laods only a few items. I'm sure that R dataframe has more the 100 items, because I write them on a file. After the data loaded, DataReader show as number of rows loaded the right number, but in the cube…
-
BOARD utilizing AI (Artificial Intelligence) and ML (Machine Learning)
Hi, Are there any instances of BOARD utilizing AI (Artificial Intelligence) and ML (Machine Learning) capabilities in any demo across any sector/ industry? We work in the fashion retail industry and have been constantly asked this question in many of our Pre-Sales meetings. Any help/ lead on this regard is highly…
-
Connect Board to Fabric Warehouse
Hello, We would like to use Fabric with its Warehouse for our Board Data. How can we connect Board to it? Kind regards, Marco Oerder
-
How can I access +Rule to access rules configuration.
I am trying to create some rules for board reporting but cannot find the window where I can create rule.
-
BFC Adjustments and Eliminations
Hi, We are trying to use the investment elimination and equity elimination functions in the BFC application. The output that we are getting is not showing us what we expect. Has anyone worked with this before that can give us some guidence here?
-
Aligning numbers when there is a negative
this might already be an idea, and I might have missed it, but is there a way to ensure numbers with negative parenthesis align when exported? Today, we get this: (1,234) 1,234 Where the Last parenthesis for the negative value sits on top of the positive value. Thanks! Matt
-
Can we hide capsule folders?
Hi Board Knowledge, do you know if we can hide the capsule folders and to show just capsules? The capsule in the below example navigates to capsules in the folder:
-
Icons in menu object
Hallo everyone, Is ist possible to customise the icons in the menu object, as there was in version 10? This function no longer seems to exist in Board 12, so that only the standard icons have to be used here? With best regards
-
Nexel "Summary"
Hello, I have been using the Nexel feature for the first time and found that when I place a formula in the down total column, the bottom left cell of the dataview changes from saying "Total" to "Summary": Does anyone know how to change this back?
-
Log Management Application
Hello, I read about the Log Management Application. How I can activate the capsule on Board 12? Best regards, Gabriele
-
Breakpoints for a regular User
Hello, Are breakpoints supposed to be ignored for a user with a regular User license? I'm trying to investigate a Procedure that fails when running as a User, but not as an Admin. Can't find any documentation regarding this. Thank you
-
Split a Yearly amount in Months according to Start Date and End Date
Dear All, 'Hope you're fine! I'm looking for splitting a full year amount between months according to a Start Date and End Date. For now, I identified 4 cubes: see below. All cubes have the 3 dimensions: Scenario / Company / Product Full Year amount (single: at Year level) Start Date (Date: at Year level) End Date (Date:…
-
Is anyone able to direct me to the Dynamics 365 documentation?
Hi all, I anticipate that I'll need to make use of the Dynamics 365 connector and the only documentation I've been able to find in the manual relates to this 2022 release: Is anyone able to direct me to the formal documentation? Ideally, I'd like something that covers the Board app for Dynamics 365. Cheers,
-
Cube visibilty lock failing when time function is applied to a cube in the same layout
Hi experts, Seeking your opinion and expert assistance with an issue related to applying time functions to a cube in the same layout where cube visibility is applied for data visibility restriction. If you use cube visibility function to lock a cube in the first picture below it works. However, If you then apply a time…
-
Possibility of calculating YTD figures based on MTD data using Rul
Hi All, I want to explore the possibilities of calculating YTD figures using MTD data using a rule. For example - Revenue for Jan 2023 - 1000 Revenue for Feb 2023 - 1000 Using Rule can we calculate and store it under new member called "YTD Revenue" YTD Revenue for Jan 2023 - 1000 YTD Revenue for Feb 2023 - 2000 Using…
-
Down Totals - What am I doing wrong?
Hello, What am I doing wrong here? In Block D, I want to display the Down Total from Block C. In the headers, I've written what Summary I'm using. In Block E, I just wanted to display what happens if I change the Summary to "Calculated".
-
Unbalanced Hierarchy - selecting descendants not available when "show only active members is ticked"
Hi, Has anyone come across on unbalanced hierarchies where if you have "Show only active members" selected in design mode, you then can't use the descendants option to select multiple members when you use the selector in play mode? I don't understand why you wouldn't be able to still select descendants on the list that's…
-
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…
