Best Of
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
Re: Capsule user profile
Hello Steven,
you can manage the visibility or action of a label with a layout inside of it. There you can place a cube including an entity for the user (group or something similar) and of course the screen with 1 or 0 as value. So the Nurse won´t see the label or an included procedure won´t work for her.
Additionally you have to hide the screen list for the capsule.
For further Information just have a look at the help: Label Enhancements
Best Regards
Dietmar