TPF Financial Budgeting Services

We can help you escape from spreadsheet Hell!

We can also integrate your financial plans with other business areas

If you want to replace silos of information with JOINED UP PLANNING contact us now!


TPF Merchandise Planning Services

The Planning Factory offer a full service in all areas of merchandise planning

You may need:

  • An audit to measure the effectiveness of your current planning process
  • Assistance with implementation of 3rd party solutions
  • Design and implementation of custom solutions
  • A quickly implemented off the shelf solution
  • Training in merchandise planning concepts and techniques

Whatever your requirements, we will do our best to provide a solution that fits your business



Visitors currently browsing this site:





Palo Protect and Copy

Jedox Palo is an open source OLAP tool.

In order to play our part in the community that is evolving around PALO we intend to provide some free resources to help PALO become more pervasive inside organisations.

TPF Jedox Palo Protect and Copy

Jedox

A workbook template that protects your palo.data formulae and allows data to be copied over them

For most users the ability to bring data directly into Excel is a major benefit of Palo. However, this approach it is not without its attendant problems.

* Users can inadvertently delete the PALO.DATAC() formulae * Users can copy values from other parts of the sheet destroying the PALO.DATAC formulae in the process * Users can try to copy data from one PALO.DATAC() formula to another and don’t understand why copying the PALO.DATAC formula doesn’t copy the value too.

T.P.F. have created a workbook that you can use as a starting point when you want to give your users the possibility of using PALO views with added protection and additional functionality.

Simply load the workbook, which only has a single tab. Use this tab as the target for your PALO Paste View and you will find that:

1. Drag and drop functionality, cut, copy, paste and paste special menu items and shortcut keys have all been disabled so you can’t delete, or copy over the PALO.DATAC formulae by mistake. They are only disabled in this workbook. Other workbooks that may be open will still function normally. (Although we would generally advise that you close other workbooks wherever possible when working with Palo views)

2. All entries to the PALO data area are validated so that you can only enter numbers, data spreads, “LIKE”s, “COPY”s or =Palo... formulae. In the current version you can’t enter text into string elements in a protected sheet.

3. You can copy values from one cell to another Palo.Data cell using the special Palo Copy button. Just put your cursor on the source value in a single cell, and then press the Palo Copy button. Select your target range and click OK - the value is now copied but the PALO formulae are unaffected.

Please Note:

The page labels and the row and column headers in the worksheet are NOT protected by this template and can still be edited / deleted.

The TPF Jedox Palo Protect and Copy Workbook is provided with no warranty (implied or otherwise). Your use of this free resource is entirely at your own risk. Your use of the resource implies your acceptance of these terms.

To get a copy of the workbook please email John Hobson using this link and provide your name and company.