Best Of
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
Re: Error when refreshing MS Office file
Hi Alexander,
Thanks for your response.
The final goal is to run the refresh automated, but I am starting with the "basic" scenario:
- Manually running a procedure with the Board Client installed in the Server machine
- Only refreshing the file (not applying any selection)
- I am logging into the server via Remote Desktop and through a user that belongs to the Administrator group
My next test will be changing the user that is running the Board Server. Before it was the "System Local", I changed it to the user I use to log in (which belongs to the Administrator group), but the error persists. I will try to ask the customer to use the local Administrator to run the Board Service.
Any more ideas are welcome though!
Thanks,
Eduard
Re: Month selection based on a Start Date and End Date
Hi,
Another solution would be to have the start/end dates as text cubes instead of using datetime as I find them quite tricky to work with. Then configure the data entry using suggested values by the entity you would like (day or month in your example). This way they can only choose between the date entities available in the database.
Then create procedure containing a nexel or a dataflow that uses the start/end date cubes to fill your cube for project horizon.