Skip to Content
avatar image
Former Member

Linking spreadsheets to input query

Hi,

I have an input query which users would like to link their own spreadsheet into as opposed to physically inputting the data into the query.

Other than using macros to write the data across, is there any other method in IP which I could try.

Thanks

Rex

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • avatar image
    Former Member
    Aug 15, 2007 at 01:11 PM

    I see this in the notes to the delta training:

     There is an ‘Offline Planning’ scenario available where the user can work in a spreadsheet on their harddrive and connect back in to the BI server. Macro’s could then be used to move the data back into a where it could be saved to the InfoCube.

    Can anyone tell me where to find the Offline Planning scenario?

    Thanks

    Rex

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Aug 21, 2007 at 07:17 AM

    redundant question - posted in wrong area.

    Add comment
    10|10000 characters needed characters exceeded