Best Of
Re: Not valid characters - how to fix?
you can set the encoding of your csv files directly in the datareader settings:
Try to find the encoding of your files and the characters should then display correctly (however, the prerequisite for this is that the characters are displayed correctly in your source file).
Cheers
Johannes
Re: selector
Hello Stefan Batalia,
you are also able to use "@Selection_Ex" in a label. Here you can define display, range, limit and so on.
You can find more information about @Selection_Ex here: layout_enhancements
In your case:
@Selection_Ex(Entity="Sales Organization",Limit="1",Display="Desc")
(where Entity is the name of your entity, limit is the number of elements to show and Display means how to show your selected element, e.g. "Desc" for description.
Hope it helps.
Regards
Johannes
Re: block-specific cell border color within a dataview: how ?
Hi interested typ,
you can change font family, size and properties like bold, italic at the bottom right of the format settings tab.
Cheers
Johannes
Re: Screen Security for Individual User
Hi Mathias,
in addition to Helmut Heimann post: this is the best way if you have enabled the capsule properties option "hide screen" and the users getting on the screen have no developer or power user rights.
If these conditions are not fulfilled, it is advisable to create your own capsule with a separate directory.
Cheers
Johannes
Re: Automatic procedures
Hello Federica Paladin,
just use the description of Björn Reuber to create a batch file and save this on the server, e.g. at Board\Jobs.
Create a new task in the windows task scheduler with your desired settings (time, iteration and so on). Set the task to trigger the batch file.
That's it.
BR
Johannes
Re: How to change position of markers in waterfall chart?
Hi Hannes Keller,
I guess you are using WinClient. In HTML Client the markers are already above the bars.
For WinClient you can add a second waterfall chart above the first one.
Just copy your waterfall chart and set the color of your bars (default, total, grand total) to transparent but enable the option "Show Labels". You also need to adjust a few more settings at your second waterfall chart like set background to transparent, hide x and y axis and so on. At the first waterfall chart you have to disable this option.
Move the second waterfall chart right over the first one and you are now able to move it a bit higher like in this example:
(I moved the secound chart a bit to the right so you can see that there are two charts.)
Let me know if you need further assistance.
Regards
Johannes
Re: data reader file name substitution variable
Hi Dinesh Chand,
just a little hint: You are not able to use @Entity in exports because it is not supported. Only @User will work.
Cheers
Johannes
Re: Data entry on totals for column algorithm
Hi Emanuela,
your workaround also allows data entry by row. Like I mentioned before there is no active possibility to edit the total row of an algorithm.
Just a workaround can fix your problem. Either like your way with split&splat on more aggregated level in a second dataview or by adding one column and a procedure for calculation. Your way is a lot easier.
Regards
Johannes
Re: How to use entities and relationships in data flow
Hi William Le,
you can use entities for different dataflow interactions.
Here are two examples:
1. If you like to pre-fill a textcube with text of an entity, you can use this entity as source. Therefore you need a textcube with the same dimension you like to use in your dataflow.
In this example you write the product description into your textcube:
You can use this maybe for editing entity member descriptions and so on (export this textcube and use a datareader to replace description).
2. You can use entities for workflow logging:
In this example I selected year 2014, salesperson = Bishop and Division = Accessories on the screen.
In a dataview you can now see this result if you run the procedure:
There are many more cases where you need to use entities, but I hope I have given you a small overview or an impetus for more ideas.
Cheers
Johannes
Re: Data entry on totals for column algorithm
Hi Emanuela,
you could try to use the "Edit block" function. There is no active possibility to change the total row of an algorithm.
In the data entry view you are able to mark all rows. You are now able to multiply all rows with a factor or you can add, subtract, divide, etc.
Your calculated total will change depending on your data entry.
Regards
Johannes