-
Date-time to be shown in label with a different time-zone. Ideas?
Hi everybody, I would like to show in a label the current date (@date) and the current time minus 1 hour. That's why Board server is running in italian time, I would like to show in the label the UK-time. I've done it with a very complex nexel Is there someone with a smarter idea? Thank you, regards, Edoardo Tags: dates…
-
NEXEL: Dynamic calculations on WEB not working
Is anyone aware of issues when using NEXEL on the WEB? I've created a process that uses a dataview incorporating a nexel calculation. The screen works perfectly on 10.1.4 Desktop but fails when used on Web. The action of the routine requires the user to select a SOURCE property. Values are selected from the SOURCE and…
-
Bubblechart goTo Capsule on bubbleclick
Hello there! I have a Home screen with a bubble chart as follows: Those bubbles represent projects and if I hover over one, it shows me some more infos like projectnumber, customer, customer adress etc... What I want is a function , so if I´m clicking on one project bubble, it should * save the specific project selection,…
-
Quarter To Date
How do I create a Quarter To Date (QTD) column in a DataView? I already have current month and Year To Date (YTD). Thanks in advance, Kit
-
Extract Board Metadata using Procedures or command lines?
While waiting for this featuresA "used by" feature on cube - Impact analysis , based on the suggestion of Björn Reuber, I've done quick ETL project using Extract Metadata features to do it myself using Talend (for xml processing) and a Board dedicated database to view the result. + However, I want to streamline the process…
-
Silent Installation BOARD Server
Hello, I'd like to install Board Server in silent mode without GUI, just over command line. Is this possible? If so, how can I do that? Thank you in advance. Kind regards Andreas
-
Firewall in Windows 2016
I have install Board Web HTML5 Server and I want to know what programs I have to allow into Firewall. The OP is Windows 2016 server. Regards
-
corporate
Hi, I am trying to add my Corporate Colors ID to the Corporate Identity. The standard Color Palette shows the following colors: But when I add one color, for example (#FF6E1432) all other (standard) colors disapear. So my question is: Is it possible to add a color to the standard color palette? Because I am free to use…
-
Data flow not working
Dear all, I want to make a data flow action with 3 cubes. 1. Cube A: 5 dimensions: month, base article, customer, production article, production manufacture. 2. Cube B: 3 dimensions: production article, production manufacture, sub article. 3. Cube C: 6 dimensions: month, base article, customer, production article,…
-
Dataflow and Ranking Functions?
Hello, We have a capsule which uses ranking functions (for example Cumulated Vertical %) on a dataview. We need to save the results, which depend on the ranking, into another cube for further analysis*. The regular way of outputting a cube is to use a dataflow. However, the dataflow does not have ranking functions as an…
-
Sourcecode Control?
In traditional programming environments, sourcecode control is the ability to track all configuration items and code contributing to the application. Does BOARD have some way of interacting with sourcecode control? I understand it's more of a graphical development environment, but I know many formats are supported by…
-
Dates shown in Browse and used in WHERE are offset by 1
Just wondering if anyone in the community has come across this issue before and found a robust/correct way of dealing with it. BROWSE doesn't match what is loaded into a CUBE. The Browse on a SQL query shown below lists several dates by employee. The Dataview below shows what is actually loaded into the relevant date…
-
Cloud| database restore
Hello there ! I just configured my database backup as follows I can find my backup now in the cloud admin portal and also in the azure storage explorer. How do I setup my restoring path now? Z:\backup"databasename" ? Thanks for help ! regards Antoni Theodorou
-
Ports used for BOARD WinClient
Hi All, What are the ports used for outgoing and incoming connections from the BOARD WinClient to BOARD Server on Cloud (Provided that everything is installed on defaults) ?? Regards Chris
-
How to print multiple objects from a Board Web screen
Hi All. Is it possible to print multiple objects (eg dataview) on a Board Web screen with a single procedure / operation? In Board client environment this can be done either by manual printing (configuring the print settings) or by procedure. The result is a print with a sheet for each selected item. Is it possible to…
-
Fast Search in Dataview - exclude mode
Hello I discovered that in the dataview fast search available in the sliding toolbar the "Exclude" option is achieved typing a "-" before the string. example: in the dataview I have folling items in row Jan Feb Mar if I type "-Feb" I will see only Jan/Mar. This behaviour is not described in the manual. has someone detected…
-
Postfix in donut-chart | cube ignoring layout selection
Hello there ! The first question is quite simple, but I cant find the solution for. I want a "€" Postfix for this value..i´ve tried with axes postfix and layout format postfix nothing worked . Second question. I have a layout with two cubes. I also have a layout selection for one of those cubes. Problem now is, the second…
-
Overlap Calculation
Hi All, Please help me how to get my "End Stock from week 27" and will be place to "Opening Stock week 28" Formula to get Opening Stock = If (Demand last last week is 0 then get Opening Stock last week else get End Stock) Formula to get End Stock = Opening Stock + Incoming - Demand
-
Dynamic selection in procedure
Hi Community, I'm struggling with a procedure I'm creating. I ask the user to select a month and I do a dataflow using this month. Then I need to get the month following the selected month if not December. I'm not sure how to do that. Could you help me please ?
-
buble chart on the web
Hello everyone , it that normal that the buble chart isn't working on the web? thanks for your help!
-
select on higher level in hierarchy
Hello all, I have this dataview where the products are on the rows. There are a couple of columns that are higher level entities: Now there's always the possibility to select by the rows' axis in the context menu of the dataview. I would like to expand that feature, by means of procedures, and build a context menu like the…
-
Entity Row Template - Default
I have a few Row Entity templates set up for different P&L formats. They all have a 'default row template' set, and then total/subtotals lines are formatted a as required. What I'm noticing is that when the user adds a new member to the 'P&L line' entity it doesn't pick up the format of the 'Default Row template' even…
-
Dataentry directly on DYNAWRITE
Dear all, does anyone knows if is possible to enable dataentry on a dynawrite with text cube? Thanks
-
Dynamic Year
We have a year selection on a screen. Based on this selection, the data gets filter.. We have Columns like Current Year Budget, Prior Year Budget, Prior Prior Year Budget. For eg: If i have year selected as 2020. Then columns are 2020 Bugdet, 2019 LE, 2018 Actuals..... I want to make the year part dynamics across the…
-
Dynamic display order for folder containers
Hi everyone, I'm trying to do the following: I have 2 folder containers on the same screen. I superpose them and have a button that aim to display either one or the other (i.e. when clicking the button, the chosen container is brought to the front). In order to do that, I created a flag cube. If the entity corresponding to…
-
How to Calculate a Day and Today?
Hi All, I want to calculate day and today, How Board handle this case?
-
How can I group specific entity members?
Hello, I created a dataview with about 1000 rows ordered by quantity. I need to see the first 3 rows with the related data and a 4° row with the sum of the 997 remaining members. How can I do? thank you
-
Calculation between entities
Hey ! For the first day of the week, its me again. Lets say we have a cube with an entity called "position" it has like 30 members showing various numbers. Now I put them into a Dataview and everything is fine. One of those entity members is the total output. What I need is, a column with the percentage amount of the total…
-
Screen get distraught
Hi all, I have created a screen in my PC. I looks fine. But when I send the same to someone else in his PC or i m trying to show these through the projector, the screen object get distraught. I have tried with screen lock property also. Please suggest what to do.
-
Problem filttring on a cube
Hello, I have a cube Reporting Group with 3 dimensions : Month, Company and Group chart of accounts[R]. Group chart of accounts[R] is the replicate of Group chart of accounts which is in the following hierarchy : |------ Company General Ledger --- Local chart of accounts |------ Group chart of accounts ---- Account…
