-
Sort dataview by Decreasing Date
Before I go to too much trouble building in a workaround I thought I'd see if anyone in the Community has found an simple way to Sort a dataview by decreasing date. Below is the issue you get in BOARD when you try to sort on the Day Entity as a block.. The issue is that it doesn't actually sort it as a 'date', but more as…
-
Cancel on interactive selection: how to cancel the procedure ?
Hello everyone, I recently built a procedure for interactive selection, started by trigger on the screen, in order to force the user to restrict his/her selection before loading any data. This is because it would otherwise generate too big reports. So in the procedure there are several interactive selection steps, on…
-
DataView Cubes not shown by columns
Hi all, I'm showing a cube by Ledger account (By Row) and by year (By Column) for some financial figures. In addition to this, I would like to add a text cube for comments based on Rows (Ledger Accounts). My problem is, that the comments cube is shown for each year when I add it into my data view. But I only want to show…
-
How to sort by a value for a axes combination in DataView
As shown in the screenshot below, we have a Sales cube and Budget cube, which have the same dimensions - Item, Area, Month, UoM. We tried to calculate the Severity (i.e. bias) and present the data in a flatten dataview showing Severity in descending order so we can find the most problematic Item/Area combinations as shown…
-
Replicate Entity More than once
Hello Citizens, i'd like to know if we can replicate an entity more than one time , that means that a i have already a replication and i wanna add another one for the same entity. Thank you for your help!
-
BOARD CLIENT ACCESS DENIED
Dear all, do you know how to solve this error? Board version is 10.3.0.51220 and we try to access via Citrix Thanks in advance for your attention.
-
DataView - Update a column when another column is changed
My requirement is the keep the change DateTime in a cube and this is updated when the user changes another column's value. For example - when the user updates column "A" (Linked to Cube A), the column "B" (Linked to Cube B) should get updated with the current date time
-
On Stop Behaviors
Hi, Does anyone have a definitive guide or understanding of how the different procedure 'on stop' behaviors work? I am most interested in understanding the implications of "Must be executed until the end." My current issue is that, if a procedure is running and a data reader kicks off (even in another database), the…
-
Interactive Axes
Hello, I'm looking to build a feature that allows the user to essentially click a button and it provide additional rows of data (almost like a drill down). I've attached two examples. The first screen shot is how the report is built now with all the data rolling up to each of the different accounts. The feature I would…
-
Column Heading
Hello, I have a pager with the Month/Year selected. All of my column headings auto populate with the Month/Year listed. Is there a way to remove the Month/Year from the column heading. I've attached a screen shot for reference.
-
It started out so promising!
After I "tortured" myself with porting some applications from #B10.5 to #B11 for quite some time now, I come to the well-known wisdom: "Never change a runnnig System!" or, as always said in Apple circles: "Never buy Revision 1". Okay, there are some things that are already working to an at least sufficient degree. I also…
-
10.5 CPSX capsule backup
The release notes for 10.5 state the following; "Features that are missing in edit mode can be used in play mode. So, if you have a NEXEL in a screen, you can still use it in play mode with the web client. If you need to develop a new nexel, we suggest to keep an update version of the capsule in the old format ".cpsx".…
-
Restricting users to create the number of entity members
Hi everyone, I want to give the facility to create entity members to my user but with a limitation that he/she can create max 5/6. How to do this ?Gabriele GalloEnrico ManganoOliver BeirneMichele RoscelliAndrea MasieroHelmut Heimann
-
Login Web Issue
HI, I have issue about Login Page in Web Mode. Every login, Screen Login redirect to Logout screen automatically. Can give me suggestion?
-
board 11 key of an entity in a dataview
Hi, In the Board 10 client is it possible to add an entity as a block on a data view and select the option to show the KEY or Description. For example if you want a report with a separate column for the account number and for the account description. In Board 11 (web client) I can not find this function anymore. Does…
-
Is there a way to customize web logon page?
A customer is asking for a way to customize (i.e. Board logo and/or background image) the logon page displayed by Board 10 Web Server: Thanks! Pietro
-
Dataview formatting with Multiple cubes
Hi, I have a complex/tricky requirement and need help on how I can achieve the required output. We need to have a data view similar as represented in the screenshot below. Currently I have 4 cubes as shown above, data is being updated through Data reader or from other source cubes through data flow. For Cube 4, I get…
-
Alignment and hierarchies in Board 11
Hi all, as in Board 11 the engine is taking care of the versioning I was wondering about the following scenario: We have an entity customer and a second called customer group. They are connected in a hierarchy. Unfortunately customers can change customer group. In that case we reload that part of the tree. Now if a cube…
-
Data readers moved to Unassigned Items
Hi community In a database I found all data readers moved to a unique group "unassigned items" All is running regularly, entities and cubes are still in their groups No strange things in reports or processes. Why this behaviour? How can I fix it? Are there consequences related to it? Hope someone can help thanks a lot!
-
Community edition of Board available ?
I have been working with EPM products in past and would like to try out BOARD and its EPM capabilities. Is there any community edition version of the product available to download and try out? What are other options to get started with some hands-on on the product ?
-
Data Entry has been disabled
Hello Everyone, i'm using "Lite License" and by changing the structre of my dataview i love the "enable data Entry" that i had, is that normal? Ps: a message shows up sending : "Data Entry has been disabled" Thank you guys!
-
Problem with PDF export (Only).
Hello All, I am facing one weird problem and unable to get right solution, Problem : Whenever i try to export any Data view or Dashboard through Board > Export > Create a PDF document i am seeing a file being created (at configured output location) but then it gets deleted automatically. The File shows name (for Example) :…
-
How to add a prefix to an entity code 
Hello, We need to prepare a new structure for a hierarchy and one idea was to tadd a prefix to the historical value. If we do it by extracting, modifiying outside of BOARD and reload the entity, the internal code will be different in we will loose the coherence in the DB. The best way would be to modify the code directly…
-
want to flow 5d cube grand total to another cube of same dimension
Hello Community, I just want to flow Grand total of a 5d cube to another cube having same dimension . Jonathan Baetens Brendan Broughton Giulia Biondi
-
SQL Error
Dear Community, I have a question about reading data from mssql DB. I have a query like this: select distinct A.c3, B.c4, C.c6 from A join B on B.c2 = A.c1 join C on C.c5 = A.c1 where .. Table C also has a column named as "c3". It ran and read data. Cubes were loaded but when I checked SQL log file I saw some strange logs.…
-
enable windows authentication
need help enabling enable windows authentication on board 11
-
(FIXED) Capsule Procedure Issue - GETBACK
Has anyone experienced issues with their capsule procedures in v10.5? I cannot get any capsule procedure to function that uses GETBACK. Instead, I get a constantly refreshing screen loop which is difficult to break out of without closing the browser (Chrome). By removing the getback, the procedure performs as it should.…
-
User list as entity members
Hello community! Is there a way to automate extracting the list of users from the system/security tab in order to easily data-read them and add them to a User entity (I would like to create a log cube by date and user to record the connexions to the capsule). Thank you for your help! Paul
-
How to put a validation for data entry Block?
I want to put a validation for data entry enabled cube. Lets take example of the above . Right Now Grand Total is 100%(I don't want to lock the grand total) In place of 20% if i add 25% Can we give some alert kind of thing ? or is there any way can we restrict Cell value(should not be greater then 100) based on grand total…
-
Using BOARD web server for other sites?
Hey, we are using the build in web server for the web client. Is there a way, that we can include self made websites and show their content? I would like to be able to create a folder in the BOARD\Web folder with a few websites (HTML, PHP or ASPX) and access them in the browser. The IIS had such a function and would be…