Best Of
Re: How to query active directory from Board ?
Hi, this article would appear to suggest that it's possible to query Active Directory information into a SQL database using linked servers and OPENQUERY, I can't say that I've tried it myself but that might be an option if you have a SQL instance available to use?
Re: Load data from Analysis Services using MDX Federator or OLEDB Connection
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.
Re: block-specific cell border color within a dataview: how ?
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.
Re: Calculation between entities
Hi Antoni,
to me it looks like your rule is not correct.
The "Gesamtleistung" normally is a calculated value and i presume that on your original cube "actuals" you have values on "Umsatzerlöse, Eigenleistung...ect" and Gesamtleistung is maybe calculated with another rule? Or do you really have values on "Geamtleistung" written in the actuals cube?
Regards
Susanne
Re: Error - The requested database is currently being modified by another user. please try again later.
I had this several times suddenly happening from one day to another when there was a selection on an entity where the tree was not consistent. Can be somewhere in the tree and has not to be the specific entity that is used for selection
Check your relationships especially top down to see if you have parent items without child items in your trees.
Regards
Susanne
Re: How user will upload a file ??
Another solution might be to use excel addin. Create layout in excel using the cube(s) where data should be loaded into, then enable data entry and just copy paste the data to be uploaded into it...
Re: Calculate contract value per month
Thank you for your extensive answer, I will try to set this up.
Re: Calculate contract value per month
Thank you, sorry but i forgot to mention that the value per month can vary, it's not lineair.
Re: Load CSV using ASCII when there is missing data
Hi,
which BOARD version did you use (and did your DataReader contain an ETL)? Cause in 10.1.3 there were some optimization regarding NULL Values and ETL
Regards
Björn
Re: Action configuration panel cut by screen
Hi,
which resolution/scaling (100% or different value) are configured within Windows
regards
Björn