Best Of

Hi Paul Wyatt - Avison Young UK, I don't know the exact structures of your data/cubes, or how likely/frequently new members will be added to these entities (these are things I'd consider in deciding which option to use), but there are a few options.

Using a procedure you could select the first client and relevant secpropclient, then dataflow between your cubes.  Then select the second client/secpropclient combination and flow and so on.  Another procedure based option would be a dataflow with a mapping cube. The mapping cube would be dimensioned by client and secproprclient, and you would populate a '1' for the client/secpropclient combinations you need.  In a dataflow you then multiply your source cube by the mapping cube and populate this into your target cube (or depending what is already in the cube you could use an IF algorithm instead if(map=1,source,target))

There might also be the possibility to use replicated entities in this case so maybe have a look at that too.

Cheers

Brendan

Hi Etienne,

I wouldn't suggest setting it up on the Board server, no, to be honest it was more a suggestion for if you already have a SQL server set up somewhere in your company which you could use, if not then it probably isn't the most convenient solution    If you did go down that route then you could schedule it all through SQL Agent, the same job could extract the data to either a SQL table or a flat file, and then use the command line call to Board to trigger a procedure for importing the data.

I've just had a quick Google (as I'm sure you've already done yourself), and to be honest it looks a lot like your only other option might be a third party tool for command-line interrogation of AD unfortunately.

If you do get a solution working be sure to share it on here, I'm sure it's something which would be of considerable interest to other community members

Kind Regards,

Rob

It sounds like you're trying to pull in data from SSAS into an existing Board database, if so then MDX Federator won't be the solution, that allows for building a Board database over SSAS but doesn't allow you to combine SSAS data with an existing Board database. If you just want to pull in a new dataset from SSAS you have a couple of options:

Option 1 would be to create an SSRS report to extract the dataset you wish to load, you can then extract that report to CSV (either manually or as a scheduled process in SQL Agent) and load it into Board as with any other flatfile. 

Option 2 would take a little more setting up but can be very useful, it's possible to create a linked server which points at an SSAS instance, you can then create a view in a SQL database to sit over the top of that linked server and return the required dataset as with any other view. You will need to do some data-cleansing as querying SSAS in this way leaves in square brackets around entity values if I remember correctly, but once you have your dataset returning as you want it you then have a simple job to set up a normal SQL datareader in Board to import the data. 

Hi, unfortunately there's currently no way I know of to set formatting for cell border colours for individual blocks, only the background and foreground colours. The closest I know of if you want to highlight certain columns with a coloured border would be to create an empty column by setting it as a text algorithm column with a value of " ", custom formatting it to have the background colour of the desired border and then placing one copy on either side of the column to be highlighted. You can then set the width of the "border" columns to be narrow enough so as to appear as a border for the column being highlighted. See below

I realise that isn't exactly what you're trying to do but perhaps it might be of some use to you or somebody else looking to highlight a column in this way, the Alert functionality could then also be used to set the "border" colour dynamically if desired.