Best Of

Thanks Helmut Heimann and Daniele Di Lorenzo for your replies, As I thought, the only way to do so is to use a dedicated cube,  I was trying to avoid this option for two reasons :

• We already have a lot of cubes that we only use in dynamic selections.
• The project is relatively big (we have already ~500 cubes)  and it’s evolving, so we might face the risk of running out of cubes as the max number of cubes is 999.

But I guess we don’t have another choice, we should optimize our use of cubes more when developing the next modules.

Thanks again  

Best regards

Ahmed Lattali

Hi Peter DeGregorio, 

This is not the Board Procedure Launcher syntax, it is the old one, as Federico Cazzalini mentioned above : Only database procedure can be called with this utility and must contain only "server-side" actions. but in the case of Broadcasting this is the syntax that should be used

Best regards,

Ahmed Lattali

Hi Miguel Angel Sisternas Seaton,

Thank you for your answer.

I have developed screen to enter project data and also I've defined configuration for suggested values. What I want to is:

-

to make a single data reader that reads data from different excel/csv/txt files and put data into one analyzer cube?

For example, I have data1.csv, data2.csv, data3.csv files. Both have id dimension. Each of them has fact columns like data1 has fact1 column, data2 has fact2 column and data3 has fact3 column.

I want to join all 3 files and write data into cube (with the structure id, fact1, fact2, fact3).

Is it possible?

I will be really grateful with your answer.

Hi Giles,

We also experienced a similar issue for one of our BOARD deployments (v.10.1.0) which related to the Procedure Launcher (as Federico suggested).

Are you running any BOARD procedures outside of BOARD using scheduled jobs (such as Windows Scheduler) and the BOARD Procedure Launcher?

If you are (and you are currently unable to upgrade to BOARD 10.1.3.41110 at this time) the solution provided to us from BOARD Support was as follows:

1. Download the procedurelauncher from link
2. Unzip the file
3. Change the extension from .ext to .exe
4. Replace the file in the folder C:\Program Files\Board\Board Server\Tools

This resolved the issue for that particular deployment.

If you happen to have a test environment, I would suggest doing it there first. 

Cheers,

Thomas

Hi C Tnu,

Can I ask, were you aware that you can place layouts into labels and control the output, as Dietmar Jeschkeit has suggested?  The reason I ask is that by understanding your level of experience, the community can provide more appropriate responses; you previously informed me that you were learning BOARD 11 and converting your previous models to it.  I have therefore assumed that you are familiar with common BOARD features, functions and modelling techniques and my responses are of a more technical nature.

So, assuming you are familiar with BOARD modelling, what you want to achieve is also easily achievable in BOARD but requrires the correct approach.  From what you've written, I am assuming that you want to display adhoc measures, selected by the user, or influenced by user selections?  If this is the case, My own approach is to create a 'report' layer.  Usually this is a single entity to control the output and a layout containing all relevant measures + the MASTER algorithm which displays the measure relating to the entity member selected.  The method of selection can either be manual from a selector or logically driven.

Image 1 below shows a single chart object.  The measure displayed is controlled by a selector [Chart Selection].  In this way, the x axis can will also be relevant to the measure. Whilst my example below is for a chart, it is easy to adapt for a label measure as you've outlined - I just don'ty have time to create a dedicated example, but also think that the principle is easily understood from the example below.

Using this method, a SORT on the highest to lowest is always active.  The master algorithm in the layout is used to display whatever measure has been selected.  Image 2 shows the makeup of the layout and the MASTER Algorithm used to select thte relevant metric.

IMAGE 1: Single chart object which can show any number of measures.  Note that the x axis is not fixed but is relative to the measure being displayed.  Also note that the SORT order is always High to low (or low to high is preferred).

IMAGE 2: Layout containing all measures and a MASTER algorithm block to display the selected measure.

If, on the other hand, this makes no sense or is irrelevant, I'll move along as these are clearly not the methods you're looking for...

Regards,

Paul