Stump the Consultant - Ask Your Questions Here

Hey Crystal - Great to hear from you as well. The best way would be to turn off write access to those cost centers within Security Manager. You can use a Named Set to group these as well to optimize future maintenance.

Thanks!

Hi Hassan - I don’t understand “turn off write access to those cost centers within Security Manager.” I know I can add which cost centers users can write too though I do not know how to exclude a certain named set of inactivated cost centers. For example, if a user has write access to a certain list of cost centers - I just need to ensure an inactivated cost center is not included, right? But do I have an option to say exclude members in this named set? Thanks!

1 Like

Our balance sheet accounts reflect the period balances for each month, when looking at a BASE Time Perspective. Is there a way to change this so that inputs for actuals and forecasts by month can be populated with the period change, rather than the ending balance? I’ve set up a Time Perspective using LAG formula to see the period change for reporting, but want to be able to input data this way as well, instead of having to input running balances.

A few admin process questions:

  1. Is it possible to download Process files? It seems there is only the option to upload.

  2. Is it possible to export our dimension tables (members, parents, properties) to a flat file, instead of needing to contact Prophix to retrieve from the backend?

  3. Is it possible to import calculations (calculation method and/or calculated TC method) for calculated members in a dimension import process?

Thanks!

2 Likes

How can I get my forecast to look at historic trends for the account / location, rather than me defining the increase manually? similar to the Trend tool in Excel

2 Likes

Thanks for the info., MJ. We will discuss your question during the webinar.

1 Like

Hi Crystal- Just jumping in here, how about if you give write access to ‘All minus inactive cost centers’?

Hello! Is there a way to sort data in a template? For example, the columns would be Actual, Plan, and Actual vs Plan, and we would like the data sorted based on the largest to smallest variance of Actual vs Plan. Thanks!

4 Likes

Are you looking to add any additional formatting to the cells within Prophix. Being able to format cells as a date within Prophix would be helpful. We are a UK customer and sometime it doesn’t pick up our dates as dates and stops formulas from working properly! Being able to format things as dates easily might help with this.

2 Likes

Hi Tracy,
Typically, Balance Sheet is as of date/ ending month end balance. Could you please provide an example why you would need to enter the net change for Actual? Is this for manual adjustments for a specific account?

Hi Angel-This is possible with custom namedset MDX. This is little more advanced and I would recommend you set-up some time with a consultant.

1 Like

This is something the Product team is looking into. It would be great if you can add it to Prophix Feedback Forum since it would show who is interested in the feature. Once you submit the feedback you can let us know and we can vote on the idea!

How do you delete workflow task comments when you roll the workflow to a new workflow and do not want to keep the workflow task comments from the prior budget cycle?

I understand now. Thanks

@rebecca.broaddus we provided an answer to your question in the webinar on May 14th. You can view the webinar here. If you have any additional questions feel free to ask them here or log a ticket at support.prophix.com and our consultants would be happy to help.

@tracy.pan we provided an answer to your question in the webinar on May 14th. You can view the webinar here. If you have any additional questions feel free to ask them here or log a ticket at support.prophix.com and our consultants would be happy to help.

@crystal.higbee we provided an answer to your question in the webinar on May 14th. You can view the webinar here. If you have any additional questions feel free to ask them here or log a ticket at support.prophix.com and our consultants would be happy to help.

Thanks Aakash. I was listening to the webinar :slight_smile:

1 Like

Hi- @mj.frazier we provided an answer to your question in the webinar on May 14th. You can view the webinar here. If you have any additional questions feel free to ask them here or log a ticket at support.prophix.com and our consultants would be happy to help.

@rob.perry- we provided an answer to your question in the webinar on May 14th. You can view the webinar here. If you have any additional questions feel free to ask them here or log a ticket at support.prophix.com and our consultants would be happy to help