-
Previous Period Stock + Today's Movement = Today's Stock
Hi All, I have a question which I've asked some others about offline and haven't found an answer too, so I thought I'd try the community. I have a 'Stock' cube (by day) and a 'Movement' cube (also by day) - dimension of each are identical, and there is sparsity (64bit) To calculate today's (closing) stock the dataflow was…
-
Datareader: View the Disc.Rec.
When a Datareader runs and it throws an exception in the column "Disc.Rec.", how can I see which records it is referring to? I want to understand why the records were not loaded. /Board 10.3 Thanks, Steven
-
Capsule user profile
Hello, I have a landing screen were buttons guide the users to different screens. However, not every user should be able to click every button. For example: A nurse should not have access to a client's medical file (screen1) and a doctor's access to the medical inventory file (screen2) should be restricted. Both screens…
-
1 Dataview serving 2 other DataViews
Hello, What is the best approach to do the following: I have 1 main DataView. The user selects a row in this DataView to load more details in 2 other DataViews (each with its own specific details) on the same screen. In other words, have the Drill-Down row functionality but then in a separate DataView on the same screen.…
-
script error
When our end-users go into their version of BOARD, they see the below error message. It doesn't seem to disrupt any functionality, but it's more of an annoyance for our end-users. Any way to stop this error from popping up? Thanks. Todd
-
Format a number as "-" if zero
Hello, I would like to replace the 0 by - and keep the other numbers formatted as they are, meaning with space between thousand and so on. Thank you and best regards Marcel
-
Dynamic yeat
Hi everyone. Is there a way to select the current year or the current month and put them into a label? Like for example: Current year : 2019 Month : March Maybe using a specific command. Thanks, Francesco
-
how to stop datareader running
How to stop data reader running for long time as shown below
-
Count selected members of an entity in procedures
Hi, is it possible to count the selected members of an entity in a procedure? I want to use it as a button function in a screen. For example, the procedure is supposed to find out when the current user calls the procedure, how many salesmen are available. Kind regards Jonas
-
Another BOARD Web error message
Can any explain what would cause the error message below? This if for a customer BOARD on-prem with IIS. They were previously able to get the logon screen, but would get an error after logging in (seeWeb error using IIS ). I tried again but now get a different error as below. No error files are being generated…
-
Problem with Transporter tool
Hello! To improve our deployment, we would like to use the Transporter tool on the DEV server. Every host is connected, but the "Compare" button doesn't work : no change/comparison appears. However, the two files _Dbimage are created, and the Transporter was run as admin. Both database are different. Have you already…
-
Get possible combination of data
Hello there, If i wanna have result of possible combination like data as below, are Board can handled it dynamically base on number of Data? Data A B C ... Output AB AC BC ... Many thanks & Regards
-
Data Reader how to set for entity
Hi , I have query on data reader append and replace . I just created 2 entity FAM_ART and SOUS_FAI In Entity SOUS_FAI - Description i want to fetch value from libelle . How to set data reader for this to fetch all value listed below .
-
transaction data server error
When I try to drill down to the transaction data of an entity, I get this error message, and it does not really tell me what the actual error is: Would this be something wrong with the drill-through protocol for transaction data, or more the layout of the screen? Thanks tma87
-
launching client on rdp
Hello everybody, We work in a mixed enviroment. Some users have Mac, so I installed Board client on Windows RDP session, where we have our ERP. As we upgraded Board to 10.3.x, we can only launch board client on RDP session with administrator power user. Doubleclicking on normal Remote Desktop User desktop start it, and…
-
Call procedure doesn't work inside of a procedure
Hello, I have a procedure "Initial launch" to execute initial data load. There are also some procedures inside this "initial launch" and some of them doesn't work. According to the log, the proceudre are launch but the output show that the different lines in the procedure didn't not work, dataflow in particular. Then if I…
-
Planning New Partners
Hi Community, seeking best advice again. In our Bottom Up planning we ask our Sales Managers to forecast the following months on customer level. They have the oppportunity to forecast existing customers but also new (to be onboarded) customers. This looks pretty much like this: I managed to get the Existing Customers to…
-
Does ETL requires to be redone after upgrade ?
Hello all, We are upgrading Board from 10.1 to 10.3 , we will then move our Database folder to the upgraded version, our question is do we have to redo ETL process again for all those protocols that already have ETL done ? Thanks and Regards
-
Can I sort by column?
I know you can use a "Sorting Cube" to rearrange the order of some entities which are by row but is there a way to reorder the entities if I am showing them by column?
-
SAP BW / Board connection - issue on data read preview
Hello I've succesfully tested a connection from SAP BW to BOARD using the trial version of the SAP Connector, but: 1) From the BOARD Connector Designer I can see the preview of the query but in Board SAP Data Reader I cannot see the preview: all fields contains a string like "abc###". This makes really difficult mapp the…
-
What is best practice for procedures database or capsule?
There are various benefits of capsule and database procedures. What is the recommended best practice for choosing to develop procedures in capsules or in the database? We develop applications for customers and maintain development and production environments. Capsule procedures offer the simplest promotion capability,…
-
cannot save capsule
Hi, I get the following error message when trying to save a new screen in an existing capsule: Tried it with the Admin User and as a Power User. Any clue how to fix that? Thanks Mathias
-
Need a Board Implementation Analyst in NYC
We are planning to build the dashboard tool by using the Enterprise Performance Management tool Board. The applicant MUST have verifiable experience with the Board tool – implementing dashboards and developing reports. Must have strong technical skills within the Board platform.
-
Restore Function Error
Hi, I just did a backup of one of my databases, did some adjustments afterward but then wanted to restorce my initial version. Now I get the message: The dropdown in the "Restore" menu shows a different name, assume that is the reason. Does anyone know where this is coming from and how I can fix that? Or is there a…
-
ASCII Reader file location
Hello, For an ASCII data reader protocol, I need to load a file on a company share drive. In the Path field I entered the location (\\servername\location) of the csv file. After clicking Refresh Board seems not to find the file. What am I doing wrong? Thanks, Steven
-
column algorithm based on excluded cubes shows random values
Dear all, some of our salesman aren`t allowed to see margin. Therefore we`ve excluded the margin cubes in database security. This works very well. But, if we`re using this margin cube in a column algorithm it shows random values/ 100%. Here the example: Cube b= AE VK (orders retail price) Cube e= AE EK (orders purchasing…
-
Trend lines (average) for Charts
Hi there, I'm searching for a solution to add trendline in my charts. For example: I have a chart which shows the Sales per week. Every week is shown in a bar. Our Sales dept. is interested in have a trendline showing the average sales of the selected period (let’s say 4 month or 20 weeks) in the same chart. Changing the…
-
Web error using IIS
Can any suggest what this error below would be caused by? A customer running on-Prem is getting it but we aren't able to access their web so can't investigate it a great deal. The customer is using IIS and we provided them with the following to set it up…
-
Is it possible to kick off Board (Cloud) Data Loader using powershell?
Hi guys, I have a client who runs BOARD in the cloud and am trying to trigger a Stored procedure (Data Loader) using a PowerShell script which i would like to schedule using the clients enterprise scheduling software. Would this be possible? If not, what would be an alternate solution? Alternatively if there was a file…
-
data entry view
Dear Community, we are currently on shifting from Desktop- to Web-Client. Does anybody know here, if the "Edit Block" function which opens the "Data Entry View" popup is also available in the HTML-Client? I haven´t found it there and also no Information in BOARD HELP. I know that the "Calculator" isn´t available in…
