-
Adding Members to Select in procedures?
How can I add members to a select with in a procedure? I have a procedure set-up which has several GL code members added. The show inactive members button is greyed out. How can I add an additional member without resetting the select and selecting all the required members?
-
USING RANK IN NEXEL
How to use Rank Function in NEXEL, IS it possible to use,What is the syntax.
-
disable column sort
Hello, Is it possible to disable the column sort when you push your headers in a dataview? Sometimes you have a dashboard which you want to present in a certain order. But users can, by mistake, click on the headers and now the dataview will sort by the column you selected. This is a great feature if you want to enter for…
-
Should Substitution work on WEB?
Has anyone used substitution formulae on BOARD 10.4 WEB? I trying to use substitution to show a user's active selections. However, I cannot get substitution to work on the WEB; I've tried using labels and dynawrite objects. I'd be happy to hear from anyone who knows what I'm doing wrong. If it is the case that…
-
How does the Preloaded Database option work for the BOARD server?
I have set a database in the Preloaded Databases option in Server configuration, but when I open the client, the database is not automatically loaded. How is this option meant to work? I also noticed in help.board.com that you can set it in the client, but it doesn't load automatically when it is set there either. I would…
-
ZOMBIE SCREEN - cannot access, edit or delete corrupted screen
Has anyone carried out changes to the database and inadvertently found that they have corrupted a screen which cannot now be accessed or deleted, creating a 'zombie' screen? I have a number of screens which will not open. On selecting, a prompt is offered to attempt a 'repair' (See attached), however, this only results in…
-
PROBLEM STATMENT
scenario: If i want to make one of my block constant and other one dynamic in same data-view ? block a: data of year 2017 i.e Historical data block b: is my budged cube which contains inhered data i.e some planned data, data copied using some procedure if i wanted my block a to be dynamic and block b to be fixed? what…
-
population pyramid chart: value markers improperly placed
Hi, I need to build population pyramid charts, and I meet the following issue: the value marker is placed improperly when the chart uses the option switch orientation combined with the option is Inverse for the Y axis: the pyramid is made of two aligned charts, the one for men uses the option switch orientation combined…
-
Selector and Pager options
Its me again! Is it possible to disable the function of selecting multiple entity childs in my selector? and if I have a date pager with 2016,2017,2018 and i want to always start with 2018 if the user opens the screen, how can i manage that? Big thanks as always! Have a nice weekend!
-
error "the requested database is being modified by another user. Please try again later"
Error in the title appears in the reports linked to a database, when I try to change the select. Moreover selections are no more applied on screens. After some time it seems solved, and now it works. What can be the reason of this error?
-
Show cube tables
Hey, quick question, is there a way to see the cube tables inside Board? It wasn´t me creating them, but i need to work with some of them and I also wanted to see the tables for understanding. Thanks again for your help and have a nice day !
-
cascade down same number to the hierarchy (relationship)
How to cascade a number from an entity to another entity related (relation ship like Europe - > Countries defined in entities). We have a cube with a number by Area (let's say Europe) and we want to use it in calculations at Country level or/and to copy it to a cube with Country dimension (not Area where it belongs to).…
-
Show particular entity members in my charts
If I have a chart using an entity with for example 5 members, it shows me 5 objects in my chart. What I want is one chart for each of those entity members. How can I manage that, without changing something in the databases entitys? I know that the enduser has the option to disable members in the charts legend but I dont…
-
Export screens as excel or txt files with dynamic name
Hello, we export screens as excel files and txt files. In BOARD I have to define a fix name, eg. Report. Now we have to add to the name of the report the month and year of the date when the report was exported, eg. Report_201806. And we have to set the files to 'read only'. I do not think it is possible with BOARD…
-
Dont show all selector items (in this case years)
Quick question, if I have a selector bar on my dashboard with a "year" entity attached it shows me every single year from 2008 to 2019 depending on my database. I just want to be able to choose between last three years like 2016 ,2017 and 2018. How can I manage that? Thanks for help!
-
Date Format - Data Reader Rejecting Records
Hello, I am currently using a Data Readers to load a cube to provide a count for Work Orders created based on a Date/Time field out of one of our SQL Tables. The Date Reader is rejecting half of the records due to a formatting error found in the Date/Time field. Below is the current SQL query I am using to load the cube:…
-
how can I view only the entity description in a label?
I need a label with only the name and the description of a particular entity without any related block value. How can I do? Thank you!
-
Items duplicated in an entity that causes data read failure.
Hi community I bump into a freakish problem today. There were some ascii data readers that sometimes was not running (randomly) All was fine on source files. I made a lot of different tests, and in one on them the data reader was alternatively running/failure No infos in log files.No error messages. Nothing. Then, digging…
-
How to display data in descending order at all levels of axes in a data view
When i'm trying to display the values in the descending order, in filter i put referenced cube and i got sorted order, but only in the leaf axes.On collapsing the data view its not showing the sorted order at the higher level axes is there any way to achieve ..!!
-
dynamic date - but not from 01.01. ...
Hi what should I do if I want to have a dynamic (date) screen but not from the 1st of january? I would like to start at the 1st of july. regards Hendrik
-
How to dynamically select the current and the previous month
Hello Community, Quick question, Is there a way to select the current + last month in only one selection action within a procedure ? Best regards, Ahmed Lattali
-
How can I manage sliding toolbar?
I want to enable or disable some buttons in sliding toolbar. How can I do that?
-
Demo for project-based budgeting
Hi All -I have a potential client that is a medium-sized project-based business. Can anyone pls provide direction where I can find demo(s) that cover the following:- bottom up budgeting for projects, with assumptions- rolling forecast as a sense check into a budget- audit trail of who was last to update a cellHoping I have…
-
Set the landing page for a user based on their log in details
Hi Guys Is it possible to set the landing page for a user based on their log in details? For example: Sharon, the CEO want to go straight to her executive dashboard after she clicks 'Log in with my Windows Account', whereas Bob, the Team Leader want to go straight to the tabular payroll data for his team when he…
-
could not use Board web
Board WEBApi not start and whenever i start then it will stop immediately. and i also could not run Board Web both on MS edge and IE. since i use http://localhost/
-
time Procedure
Hello everyone, i'd like to know if there is a way to minimize the time of the procedure? Thank you for you help !
-
Webclient known issues
Hey, is there a documentation or tool tips on using the webclient? And does it contain known issues? For example, layouts that work good and normal in the desktop version but in webclient: - waterfall charts that do not work properly (empty layout)? - "Oops"-Layouts just not working? another empty layout! - zeroes shown…
-
Board Web (Screen List & Formating issues)
Hi, I have two questions regarding Board Web (tested in Chrome and Firefox). Screenlist: I want the screen list on the left not to be shown. I disabled the screen list in the client, as well as the sliding panel. Still it appears in the web. Is there another option I need to disable? Formating: I have a numeric ID which…
-
Sample file for FC 4.0?
Hi there, Is there any way to get the sample file of financial consolidation 4.0 from the recorded webinar? It helps us build a simple demo for marketing purpose. Thanks in advance for any help. Woo
-
How does BOARD handle concurrent execution of procedures?
Hello, We have a procedure which clears some cubes and then runs some data flows to reload the cubes. The procedure may be triggered by user activity. If two users cause the procedure to run at about the same time what happens? Does one run and complete before the other is executed? If not is there a way to single thread…