-
How can I use existing entities/cubes available on database_A in database_B?
Hello community! I would like to use our databases as efficient as possible. Data in Board database_A are loaded into entities. I need exact the same data in Board database_B. Extracting and loading the ASCII-extract is an option, but I would like to avoid this as it creates too much duplication and processing. On a…
-
Entity Statistics
Hi all, is it possible to have entities statistics? I would like to know which cubes use a specific entity. Thanks!
-
excel column limit
hi community, i have a datreader from excel file, i wanto to know if there is a column limit to import data from excel. Regards Andrea
-
BOARD 10.3 - How are URLs within Text cells recognised when selected
I would like to understand how URLs can be used as links when they are loaded into a TEXT type infocube and displayed in WEB. I have such a cube as seen below but cannot get the urls to do anything other than sit very still. The release notes state the following: Fixes and Minor Changes * The Data Entry on the web has been…
-
Dataview symbol after function
Is there a way to have the figures centralised aligned and have the percentage sign next to the figure rather than at the end of the block? Also is it possible to get the percentage sign inside parenthesis'?
-
How to find customers with no sales
Our user wants to see what customers have not made a purchase in a certain time frame. I have tried show all on the axis options and this seems to mostly work by sorting on the amount to group the zeros together. Have also tried, in case where we have a current year and prior year sorting on the current year amount to…
-
Mashup Between SQL and Excel Data Sources
Greetings, I am currently trying to do a mash up with a transactional SQL table and do a V-Lookup type function to return additional fields from an Excel data source to populate for each record we capture in our CRM. I've attempted to use Nexel, however, I'm doubtful that this is solution to this project. I've created 2…
-
Colouring Layout
Hi all. I have dataview like this. In this case, if ach < time factor, the colour is red else green. what should i do sir ? thanks. and i have layout like this.
-
Export Excel from Cloud to OnPremise
Hello, how can i create in the cloud a procedure which exports an excel file and deposits onpremise? or how can users you access it? Thanks Philipp
-
year-to-date for past years
I'm trying to formulate a report where it shows year-to-date actuals for the current year, and also where our actuals were on the exact same day for previous years. For example, today is January 15th, and I want the report to show: Fiscal Year 2017: actuals from start of fiscal year to January 15th of fiscal year 2017…
-
Best colour for BOARD data input cells in a DataView?
I'm looking for opinions as to what colours you think are most appropriate for BOARD data input enabled cells in a DataView. As most BOARD users are probably aware, the default is a pale yellow (R255 G250 B205) background with a black text: You can of course change this default within a capsule and copy the formatting…
-
Rebuild / Load NEXEL-Files
Is there a way to restore a saved NEXEL table (xxx.nxl)? In the concrete case I have saved a very complex DataView as xxx.nxl via the NEXEL-Editor, in order to execute the calculations afterwards by procedure call. I accidentally deleted the "original" DataView ;-( and now unfortunately have to work on the NEXEL table…
-
YTD Previous Month by day
Hi, I have a YTD report that automate on a monthly bases based on YTD that runs on the 9th of each month. In the report the YTD is offset by 7 days therefore the numbers in the report will always be from the beginning of the year 01/01/2018 - 02 of each month driven by Day selector. I now have a new requirement to produce…
-
Is there any way to Drag and Concatenate more than one SQL Field by Drag and Drop(Auto mode) in Data
Hello Team, Happy New year, now my question is, i have 2 SQL fields FirstName and Lastname, I have created Just one Entity called 'Name' Now i want to concatenate SQL fields FirstName and LastName (FirstName + LastName = Name) and append it to my entity Name lets say if i do not want to use manual option for this, so is…
-
export multiple folder tabs in a screen to the same excel file
Hi....right now, it is possible in Board to export a single DataView into Excel regularly or in Flattening Mode. I have a screen that has multiple DataViews in different folder tabs. I am wondering if it is possible to export all these DataViews (in different tabs) to the same Excel file. This would save me alot of time on…
-
Master License as authorized visitor?
Is it possible to use a Master License as an authorized visitor in another server?. i have a developer master license installed in my computer, but i'd like to login in other server, may i use the same license?, is it possible to use just one license for this? Thanks for your help.
-
Normalize option: Do not fix missing relationships (not recommended)
Hello, Would you please explain exactly what procedure configure action Data Read > Relationships > Normalize option "Do not fix missing relationships (not recommended)" does? There's a double negative in there ... is the recommendation to always check that box? That fixing relationships is not recommended and to therefore…
-
Error: Index was outside the bounds of the array.
Hey everyone. I have the bove mentioned Error massage in our web client and cannot finde the reason for it. The funktion of the screen is obersioly not harmed by this. But the massage comes up every time we open the screen. Any ideas what the reason is? Regards, Jörn
-
On a BOARD cloud environment is there a variable available to identify whether the instance is the S
On BOARD cloud is there a variable available that could identify whether the instance is the Sandbox or Production environment? I would like to use such a variable to control some extracts (via a procedure) from BOARD to the appropriate Azure folder . I have thought about creating an info cube to store such information but…
-
Layout algorithm in rows / columns
Hello, I would like to know if it is possible to build a layout using in rows the algorithm. I always use layouts like this with algorithm in columns: Layout configuration - Data - Axes by row BU Layout output I would like to have as output: Is it possible? How I have to configure the layout? Best regards, Gabriele
-
Installation details
Our organisation has just signed up as a partner. I have completed the initial courses and am looking to move onto the exercises. My question is what version of Board should i be downloading and installing? Regards, Andrew
-
How to create a report with several cubes grouped in lines?
Hi, In Excel I have a report that looks like this: What would be needed in board in order to create a similar structure, where the different cubes are over each other (by rows) instead of side by side (by colums)? BR, Ray
-
switch board version 9.0.4 to 10.1.4
Anyone out there who can tell me something about the update from version 9.0.4 to 10.1.4? Maybe some information about problems and their solutions, where you have to look for and what you have to do that the reports are running? Thank you! Hendrik
-
Change web interface
Hi, i was trying to change the HTML5 interface, trying to customize the ribbon bar and web landing page login. How can i change those? I have been mentioned these can be configured and changed but was wondering how Thanks in advance,
-
Why aren't my percentages correct for the Total columns/rows?
Hi I'm a fairly new user of Board, so this might be something obvious - I've been building financial reports, but with my percentage calculations, through using rules, the percentages are correct on the data columns, but incorrect on both the total columns/rows. Values are all divided by 1000 to get $'000 for my financial…
-
Export pdf Board 10.3
Hello, I'd like to know why i'm getting this error when i try to export a PDF document from a dataview! i have to mention that i'm getting this error on my App_data logq :
-
Upgrade to 10.3 & IIS
Hi Guys, I've just updated a Board server to 10.3 and I'm facing an error when trying to login using the web client : I have followed the steps from How to setup Microsoft IIS with Board Server 10 doc, so I'm not sur what I did wrong. Does somebody can help me please ? Thanks !
-
Excel Export Rich Client/ Windows Client
Hi Together Actually we have the issue, that when I export in our test environement a data view to Excel, just a few rows (really random) will be exportet. But not all of the dataview. Is this a known Error with the Board version 10.3.0.50803? This happens only in the Rich Client. It's a Dataview with 2 Entities in…
-
Is it possible to use Data reader without creating Entity, Info cube and Relationships ?!
Hello Team, I was just wondering how awesome it would be if i can use Data Reader, Connect to my SQL Database > Pass a Custom Query and see entities and info-cubes, dimensions and measures gets created. It is possible by any chance ?! or we compulsory need to create entities first, info-cube, relation ship and then use…
-
Dynamic selection not working
Dear Community, I have a problem when I do a dynamic selection on entities. For example, the entity "Enseigne" is not empty and there are cubes that are structered by this entity but I can't find them in the list of cubes below. I have the same problem on all my entities of this database. Do you have any idea about this?…
