Best Of
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
Re: Data Changes
Hello,
Thank you for your reply. I want to run the data reader say every 30mins and bring in any changes during that 30min period. I have played around with your suggestions and can amend the data using a where clause. However, this is financial data and the $ values are stored in a Infocube, which only sums or replaces which deletes all data in the cube except any changes made within the last 30mins. How do I amend the data in a info cube?
Thank you, Alex
Re: Change capsule database doesn't work
Hi Edgars Kancans,
Unfortunately, I didn't find any solution, what I did is getting a recent backup (two weeks old) of the capsule, then I did the change database.
Hope it helps,
Best regards,
Re: Board Broadcasting as scheduled task
Thanks Domenico,
The scheduled task works, even if I disconnect from the RDP using the red x the user still logged in
You and Björn Reuber both helped me I really appreciate it but I don’t know which answer should I mark as correct
Re: How to dynamically select the current and the previous month
Thanks Helmut Heimann and Daniele Di Lorenzo for your replies, As I thought, the only way to do so is to use a dedicated cube, I was trying to avoid this option for two reasons :
- We already have a lot of cubes that we only use in dynamic selections.
- The project is relatively big (we have already ~500 cubes) and it’s evolving, so we might face the risk of running out of cubes as the max number of cubes is 999.
But I guess we don’t have another choice, we should optimize our use of cubes more when developing the next modules.
Thanks again
Best regards
Ahmed Lattali