Best Of
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.
Re: Community Website Bugs
Hi Paul Wyatt - Avison Young UK & Malav Shelat,
Thank you for flagging this to us. Jive X platform, unfortunately, has been experiencing a number of technical issues lately. After being acquired by Lithium, we witnessed not just lack of development but inability to maintain the existing functionality. We are constantly in touch with the support team, but as soon as one ticket is closed, we need to open another one.
We are not ignoring these issues, though, and have started exploring our options. We want our customers and partners to stay active, communicate, earn points, share experiences and much more. Ensuring the community functionality is fit for purpose and serves our customers in the best way is our main priority. We are genuinely sorry for the bad experience with the community platform at the moment and we'll do our best to fix the issues with the support team as soon as possible. We have a couple of announcements coming down the line and we will speed things up even more, considering that Jive X issues are worsening.
As for the other points you've made, we always welcome feedback which now has been shared with Board product team and a member of that team will follow up shortly as well.
Kind regards,
Anastasia
Re: Impossible to reset selections after apply dynamic selection using a procedure
Hi Paul,
thank for your help.
Before posting this question I created a procedure to reset the selection related to entity "Responsabile".
Unfortunately I created a wrong procedure, without "Apply selection to screen" step so I wasn't unable to reset the selector.
Using a correct version of the procedure now I'm able to reset the selection made using the selector.
Regards,
Paolo