Best Of
Re: how to make bar chart columns with different width?
Hello Ray,
you can do something similar to what you want. The only thing missing is to set up the width.
You can achieve it by having another two blocks in the series. These two are set to transparent and also with the one in the middle set to cluster. The blue one in the picture is set to none and the first one in the layout. So it is in the background of the other three.

Re: Dealing with large SQL Views in Daily Load
Hi Mathias,
in addition to what Björn said you should also have a look at this How to: Optimize Datareader performance.
Regards
Dietmar
Re: Entity Statistics
Hi Massimo,
you can extract the metadata from your database and you will find two files "entities.txt" and "cubes.txt". In the file "cubes.txt" you will find a column with the header "EntityIdx" and merge this with the column "Idx" of the file "entities.txt".
Then you have all the information you need. Of course you can set up entities and cubes in your BOARD application to import this data and show it in BOARD.



Re: Changing Header Positions in Layout Selects
Another easy option is to use other codes for the entity and set the sort order of the entity to code. So e.g. if you are using Code 01 for PLAN and 02 for IST the sorting isn´t belonging to your selection and it is sorted by the code of the entity.
Of course you must mention the code for your import of data.
regards
Dietmar Jeschkeit
Re: Disable Data Entry on Grand Totals
Hi Mathias,
you need a block with a value <> 0 in the Total. This one will lock the total.
Re: Web client: Chart show label
Hi Jörn,
which version you use? In 10.3 it works fine in the web (see Picture). Browser is Chrome.
Re: Process: Go to capsule and apply data selection
Hi Jonas Franck,
in your procedure one step is missing. After Step 3 (by the way this step should be not necessary) you have to assign the selection to the screen before refreshing.

BR
Dietmar
Re: Excel DATE and EDATE functions
Hi Vikash G,
in addition to Alexander Kappes you can use the SLN Formula for calculating the depreciation.
It is: SLN(Initial cost of asset, Asset value at the end of the depreciation, Periods over which asset is depreciated)
BR
Dietmar
Re: Prior Year Total
Hi Mark Schad,
the easiest way is to have a second cube where you change the dimension month to year. Then fill this cube via dataflow.
This cube reacts with the year when you select the month. If you then set previous year for this block you get the data from entire last year.
BR
Dietmar

