-
Store Procedure
Hi All, Are board can connect Store Procedure SQL? Thanks.
-
One quick question on Data picker using entity !?
Hello Team, is it possible to use Data picker with using Physical Name and any specific entity in that cube ? for example: I want to Data which is in cube say V111 (physical name of cube), within that cube there is a entity member Name X12345. what i want to do is to use Data picker in rule which will fetch value of entity…
-
Detail-by references disappears when using conditional algorithm based on entity.
Hello Team, I have a Dataview Layout as this Under axis I have these entities: and under data i have these: Content D, E and F have References by (div-dept, sample image shown below) All are cube and algorithm contents, For F Content , i have entered an algorithm (E-D) and under references i have detailed it by Different…
-
Cube Version
HI All, I have question about cube version. When i created cube with version like this Why cube detected last version? can i modify cube version that i choose?
-
Export/printing to PDF sizes
May be a silly question but I can't seem to find a setting to change the size of the export. It defaults to A4 is there a way to change this setting to be at A3?
-
Rule results from rows that are filtered out?
Hi all, I created a rule on a 'reporting index' entity. That entity has a relation to a 'reporting index level' entity. All of the elements in level 1 are computed as sums from elements in level 2. I want to be able to show/hide the second level - the sums of the first level need to stay though. Is this realisable with…
-
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,
