-
GVA Introduction video
I was asked by my company to put together a short high level video demonstrating three aspects of our external client tool. Whilst discussing this with Andrew Rae, I found that I could not share with him the content and so decided to share it here for all to see. I welcome any feedback and opinions. At the time of…
-
how to make bar chart columns with different width?
Hi, right now I have this type of chart: And I'd rather have it look like this: The idea is to have bars with different width in order to put some behind others and still be able to see their value Is this possible at all and if so how? BR, Ray
-
Align cube from ROLAP version
Hi, is it possible to refresh the aggregated versions (align) of a cube with a ROLAP version that is on the lowest level? BR, Ray
-
enable broadcast / mailserver feature
Hi board members, we would like to use the mail function in board. I tested it with several smtp accounts (e.g. gmail) and still got the same useless error: "Procedure usermail failed" (without any further log informations). Are they any hints and tips? Best Paul
-
how to create bar charts with several stacks?
Hi, I would like to create a bar chart with many stacking groups as in the following example: Right now there are two stacking groups - combine by stack and combine by stack100. I don't see the option to have put some elements on the first stack, then combine others on a second stack and so on. There would be the…
-
MXC Cube - No Totals
Is it possible to get a grand total of rows and columns when using an MXC Cube? I want to understand MXC cubes more. One thing I have found is that I cannot get row and column totals when using an MXC cube and so have to create a duplicate of the MXC cube, setting the datatype to DOUBLE and not MXC. I then have to create a…
-
Is it possible to "drill to screen" as an action of a procedure?
Hi, Using the drill to screen action I'm able to set a selection for the target screen. As procedure action there's a "Apply selection to current screen" that allows to make the selection for the current screen. As a second step I can use the "Go to screen" action and go to the screen of my choice. The disadvantage of…
-
Extract layout to local machine
Has anyone been able to extract a layout (in csv) to the users local machine rather than the BOARD server? I've tried a few things with no luck so hoping someone else can help. The client's current workaround is to map the drive with single folder access on the users machine to allow them to access the file so they can…
-
Full RAM Mode / Benchmarking : how much time does it take to load your DB in RAM ?
Hi everyone, I would like to do a bit of benchmarking to understand better our performance and look into possible infrastructure improvements. My current issue is that we have large databases (typically 50Gb) that takes a lot of time to load into RAM when used the first time. Usually this takes between 20min and 40min. So…
-
How can I change all screens with one selector in my master screen?
Hello all, how can I change all my screens in the capsule with one selector in my first screen from Jan.18 to Feb.18? Our standard sales report has 15 screens with different dataviews and charts. I don't want to change each month each screen to the next month. I want to change the selector of my first screen and all others…
-
Color coding in treemap diagrams
If I want to display the following data in a treemap diagram, I encounter a problem: The scaling in the Treemap object is obviously correct. But, in my opinion, the color coding is faulty (or at least not comprehensible/understandable for me). If a treemap is created from the data table at the Top, the color coding (an…
-
Upcoming BOARD versions
Is there actually a roadmap showing which features, functions and/or changes are planned for the upcoming versions of BOARD? I am particularly interested in whether the large number of suggestions for improvement that have also been submitted via this forum are taken into consideration.
-
Performance trade-offs : 128 bits sparse versus dense and 64bits sparse ?
Hi all, everything is in the title: very often when designing cubes or cube versioning, I have a choice between these two kinds of structure: - Entity A (D), Entity B (S), Entity C (S), Entity D (S), Entity E (S) => Smaller physical cube size but 128bits sparsity file. - Entity A (D), Entity B (D), Entity C (S), Entity D…
-
Can i copy/paste data from Excel into BOARD?
Hi, would it be possible to copy data (or a set of cells/a range) from Excel directly into BOARD? i need to feed some data from excel into a planning table and i am not sure this can be done. Are there any logics to be considered? Thanks
-
Passing values - no CSV in here please
Hello BOARD community. I wanted to contribute before I asked a question but this issue is perplexing and I really want to know if it can be achieved. I want to disseminate values of a cube to other cubes which have the exact same members but use differently named entities and live as parents in other trees. I do appreciate…
-
How to query active directory from Board ?
Hi everyone, I am currently looking for ways to import in a Board database a few key information about our users, coming from Active Directory. Basically, our user names are email addresses, and I would like to use AD information to associate the location, company, manager name, etc. to our users. This would be very useful…
-
Load CSV using ASCII when there is missing data
Hi, I receive a daily CSV from a third party. The first row is the column header, the first 5 columns always have data and the next two columns only occasionally have data. When I load using ASCII data reader, I can't load columns 6 and 7 because the first row of actual data is almost always blank for these columns. If I…
-
Is the Cognitive Space a game changer?
Hi all, what do you think about the cognitivespace? What use cases do you see in existing solutions and in the future especially for the nlq (native language querying)? How do you explain and demo this to new / existing customers? Do you see the need to change development guidelines like using prefixes to categorize cubes…
-
Conditional display of columns on a dataview
I have this dataview and I would like to find a nice way to hide/show the 3, 6, 9 month columns without having to go into the layout and select the hide block option. I started off with a small data entry cube so that I can place a tick to decide which columns I want to show but I can't find a way to have that affect which…
-
Rolling 3 month Average in a dataview
Can I create a moving average in a dataview? For example I would like 12 months of data as Bars on a chart and then have a 3 month moving average as a line on the chart so lets say that periods 9,10,11,12 had the values 38, 40, 45, 49 on my chart the bar for period 12 would be at 49 and the 3 month ave for period 12 would…
-
Can i default a selection on current month?
Hi, is it possible to default a selection (when landing or opening a screen) on a specific month or just the current date? Shall i use a select based on cube? is there any alternative for this or shall i consider using a custom time entity? thanks in advance Regards,
-
is it possible to add an element into BOARD for planning or budgeting?
Hello, i'm quite new to the BOARD solution so i was wondering if it was possible to add a new element into a dimension for planning and evaluating a future impact of it on the Budget. I would like to add a new Product to my product portfolio and be able to plan a sales budget for it. Is it possible? How should i do it?…
-
How can i export my Screen in Powerpoint?
Hi, i was wondering if there is any functionality or feature i can use to export a screen in Powerpoint? Can i also do it from the Web Browser? I am currently printing the screen using the Browser Print. Regards,
-
Limit drill down
Hello there, Is there a way to limit the drilldown functionality for certain users in particular screens? If so, is it applicable on the Windows Client as well as on the browser? Thanks
-
Unable to Login: 64 bit license Error
Hello, after applying licence, I get the following error: "the license does not allow Board to run in 64 bit Mode" Could you help me understand, what am i missing to correctly configure the login and access by BOARD instance? Thanks in advance
-
Unable to apply analytical function 
Hi, I would like to apply analytical functions to a series that varies with time. I have an infocube with 1 dimension (day) When I select a function in the Analytics tab of the block configuration, the resulting cells show "0", regardless the function selected. Can you help me out? Thanks,
-
How to export a table from BOARD into PDF
Hi everyone, how do i export a table from BOARD into PDF? is it something i can do easily by myself? Thanks,