-
Column Algorithm user language dependent
Hi all. I need some idea to put in place a translation within a dataview. The dataview is quite complex, so i'll prefer a simple solution saving me the time to entirely edit all the layouts. I have a formula as follows: if(a=1;"En cours";if(a=2;"En attente";if(a=3;"Envoyé";"Rejeté")))) I know that i can eventually create…
-
Board Web-Client 10.3.0.50924: Error Message after using a dynamic selection in a procedure:
Hallo everybody! After using a dynamic selection I get the following error message: Behind the Label "Mitarbeiter" there is the following database procedure: In the second step there ist a dynamic selection on a specific cube: In the third step I see the right numbers of employees and I can choose one or more employees.…
-
Select the entity on a line with a procedure
Hello, I know that we have a Master Layout option when we set a dataview. But is there a way to select the by row the entity of a dataview line with a procedure? Thank you and best regards Marcel
-
Can we apply Pager/Selector on a specific object only ?!
Hello there, Is it possible to apply Pagers/Selectors in a way that they Interact or lets sat they are applied on specific objects only, for example, * I have Data view and a trend chart on my Dashboard, * I have one Pager and one selector on my dashboard for filtering the data Now what if i want to apply the Pager only on…
-
Hide Zero Data With Vertical Axes
Hi, I have setting configuration to mapping data based on product and location. and then on the other screen i want to show my data based on my setting. my dataview shown align with Vertical Axes, but why Hide Zero and Not Show ALL function not working? When I try to change Alignment to Horizontal, its work. So how to hide…
-
How to use block created in formula editor as a cube ?!
Hello there , I was just wondering if i could use a block created in formula editor like a cube, for example, 1. as shown in image below, i created a Block called SingleRule_Block, 2.Now i went to Layout and created a C block with Column Algorithm as a/b 3. Now when i see in the DataView, block C does not show me any…
-
capsule translation - Board doesn't recognises CapsuleTranslation.csv
Hello everybody, As an admin I have created a capsule with a simple Screen. On the Screen is a data view showing the turnover. Now I have another account where the language ist set to Italian. In the board Folder ist the "CapsuleTranslation.csv" file . If I fill in the translated words, Board uses the translated words…
-
Tracking User Data Entry
Is there a way to track what users made a data entry? For Instance, I have a screen where users can put comments on specific lines of a financial report. Is there a way to show what user put in that comment? Other than going into the Cloud administration and looking at the logs. If not, I could always have them enter their…
-
Server Configuration Error
Hi, I have problem with my Connect to Board. I dont know why this is happend. I have been trying to Uninstall and Install again that Board Client, and its nothing happend. Here is my attachment
-
Excel add-in
Hi Everyone, We are using Board version 10.1.4 and planing to use Excel Add-in. It would be much appreciated if you can advise me on the following: 1. What's the benefit of this excel add-in? 2.Will the excel Add-in (version 10.1.4) support my Microsoft excel 2010 version? Thanks a lot for your help,
-
Opening Capsule from Command line form different folder
Hi all, we are using a capsule for out datareader procedures. This capsule will be opened via command line every night. This works fine. Now we want to shift this capsule from C:\Board\Capsules to the folder C:\Board\Capsules\Administration. But when we do this, we cannot open this capusel from command line. Any ideas how…
-
Applying Count/Distinct Count operation on Dimension
Hello there, I am having little trouble finding a data operation which can reflect my dimensional values in form of count or lets say numbers, For example, I have two Columns like , DimensionMeasureBldg110Bldg220Bldg350Bldg470 What i want to get is Total Sum of Measures / Total Count of Dimensions and average it out, 150/4…
-
Text Format in Label Win-Client vs. WEB
Hi all, I'm searching for a way to show format of text in labels in the web client. I'm using labels with a data layout to show some explanation to our screens. In the Win-Client the format of the text (especially text paragraphs) looks fine. But in the web client all formats are gone :-( Any ideas? Regards, Jörn
-
How to calculate as Dinamic
Hi, I have data like this : Safety Stock (Enable Data Entry) Setting Safety Stock : 2 Week : Wc01 Wc02 Wc03 Wc04 Wc05 Wc06 Demand : 10 10 10 10 10 10 Safety Stock : [........] [........] [........] [........] [........] [........] I want calculate Demand to Safety Stock as Dinamic. When I want Calculate Safety Stock,…
-
How to save the current selection (to file/db/cube/...)?
Hello, I'd like to save the user's current selection via a procedure (click on button to save), in order to be able to restore them later (click on button to retrieve and set). This way user's would have their own saved queries (I intend to limit the amount to 5 and have 5 Buttons). What I've tried doing is storing the…
-
I'm trying to add a capsule folder to an existing profile but board shows an error. Does anyone know
hello, I'm working on the security profiles, and I'm trying to add a capsule folder to an existing profile but board shows an error. Does anyone know what the problem might be ? best regards. security profile security
-
Formula Editor - Layout Error
Dear All, I want to use Nexel in My Dataview Layout. But, After Add Block I got error message. What is the purpose of the message in question? Is there a better way to display alert on my layout ? Thanks
-
Can we open multiple screens at the same time while we opening any Capsule ?!
Hello there, I am just curious to know that is there any possibility to open Multiple screens at the same time while opening any capsule, what currently i am facing is while i open any capsule i am just able to see one screen , what i want to do is to get 3 screens open when i open any capsule ( I am aware about containers…
-
Data does not appear to be supported format ?!
Hello There, I am trying to upload data through Data Fast Track > Local file > and my raw data file is in xlsx format , however when i am trying to import data into database its giving me an error stating "The Data doest not appear to be in supported foramt", i tired fixing Data format to YYYYMMDD , also removed blank…
-
Web Client Pager in ATO
Hello, I have a Pager in ATO to create/edit entity members, the pager works fine in the desktop client, whereas in Web client, we can't see the Code field unless we extend the height of the window. Does anyone have this problem ? What can we do to solve it ? Any help would be very appreciated Best regards
-
detail by with data picker
Hello all, It seems that when using the data picker functionality in a layout (using Nexel rather than Rules), that if a detail by is used on a block the entity being detailed by is ignored, and the total is displayed for every item. In a simple example, if I set a single rule for a block to be "=@[V001]" , and then put…
-
export to excel
Hi Community I have a doubt that just to export a dataview to excel also do we need ms office license to board should be true? Thanks in Advance.
-
Changing Header Positions in Layout Selects
Hey there I just want to know if its possible to change the column header positions. I want PLAN to show first and then the second member IST I don´t think thats possible but thanks in advance =) kind regards Toni
-
Combine Cubes with different entities
The goal is to produce to the following structure: Employee / Activity / Hours / ( activity / capacity ) So i have a cube with the employees, activities and hours for each day and i have a cube with the capacity per day per employee. And also the time period will change, so the capacity is a variable. The report can be for…
-
Fine tuning Set-Trigger on DataView
We have a dataview with (for simplicity sake) 3 blocks in the layout. Each block has data entry enabled. Dataview has set-trigger defined - this procedure is executing some logic/flows with the new numbers. The logic in the procedure is assuming the that all 3 blocks have changed and logic needs to be executed for those…
-
Procedure Failing - "Index out of range"
I have a procedure that fails on the overnight schedule but works fine when I run it manually. Error message is "Index was out of range. Must be non-negative and less that the size of the collections. Parameter name: Index" The only time I've seen this message before was when a step of the procedure is for a Data Reader…
-
Get Last Value each 10 Days
Hi everyone, Currently, I had a problem to find a way for getting last value each 10 Days (based on my Aging time). I tried to use Last Value function but didn't work (cause Last Value function characteristic -it won't stop till the time end- ). Is everyone any some suggestions? The example I attached. Thank you. Have a…
-
How to write data entry back to source database?
We've recently moved to a world of trying to maintain a clean production environment and making all changes in dev and then periodically copying the entire dev database across to live. However..... We've realised that data entry performed in live now gets overwritten. We have some data entry enabled for both entities and…
-
Disable left menu in HTML5 iframe
Hi, when i try to embed a capsule in my website using iframe, the left side menu still appears. Using it, users have access to other screens. Is there a way to view a capsule in my site page without viewing the left sidebar of the BOARD web interface preventing free navigation among screens? Thanks,
-
Keep Header Rows Empty in Excel
Hi Boarders! When I export a table to Excel, Board adds 0's into the empty header rows. In the example attached, "EXPENSES", "Workforce" and "Senior Medical Officers (SMO's)" are empty header rows in the Board data view but they contain 0 in the downloaded Excel sheet. Can I quickly download to an Excel spreadsheet but…