Best Of

Hi Ray Martens

How often will new products be added?

I'd say there's a few different ways, but one solution would be to use the screen select to limit the customers as required (maybe a user select on on product and a dynamic select on customer), and then apply a layout select to the dataview showing the sales cube to select all products (just make sure you get your to/keep correct).  The screen will limit the customers showing but the layout select will show sales for all products.

The main issue with this is if new products are added the layout select will need to be manually updated.

Hi William Limy, 

Another option, more similar to what you're currently trying, is rather than extracting each cube separately you can extract a layout. This will allow you to generate an ascii file containing the data from both your cubes, and so allow you to load into the single target cube as you need.

This option is down the bottom of the Extract tab, and you just need to set up your layout the same way you would set it up in a Dataview

Hope this helps

Are the files you need to connect to always the same, just with data being overwritten/added?

If so, then depending on the format of the data in your workbook, using Excel Tables and Range names you can set up a SQL Connection from BOARD to each Excel workbook which you can then read in with a SQL datareader.

The table(s) you have created in the Excel workbook will appear in the RDB list on your datareader.  And through the combination of Tables and Range names they will be dynamic, so as new data is added to the excel table it will be picked up by the connection/datareader and read into BOARD.

Then you would just would need to use either formulas or VBA to ensure the data is being appended to the relevant tables in each Excel workbook.

Another option which I have experimented with mixed results (but never implemented as I've had no need) is to use the Office Add-in and VBA code to essentially 'paste' the values into a BOARD layout with 'save/undo' mode enabled.

Hi Ford Reid, going from your excel sample I'm assuming you want one cube/block to be displayed across multiple columns (the one displaying '1's), 1 for each month, and then the other (displaying the dates) to only show a single column?

If I have this correct it should be easily possible.

First remove 'month' from the by column axes.  This would display one column  for each block.

Go to the 'References' tab on the block you wish to split out by month and select month under 'Detail By'.  This should then detail (ie. display) that block by month, which will put a column for each month.

you set this here.. 

Leaving the other blocks as is (ie. no detail by) will leave them with a single column, and the 'detailed by' block will show multiple columns.

Hope this helps and is what you were after.

Cheers