Excel Pivot Tables with analysis services

  • Hi,

    I need to build a template for users so they can select only a few range of values in excel for a column. Once they enter some values in the template, we need to load them to the database. The problem is that the users keep making mistakes when entering the data. That is why they need to be restricted to enter only certain values in the column.

    The range of values acceptable values are coming from an SSAS cube.

    So I created a worksheet say "A" where I get the range of values from the cube using a Pivot table and a .odc connection to the cube within excel.

    In a different worksheet named "A_Template" I read the values from the sheet A and restrict users to select only those.

    Now I need to share this workbook. What is the best way of sharing this workbook since we have SSAS connections in it.

    Also is there a better way of restricting users from entering mistakes in the template file? Please suggest

    Thanks,

    Praveena.

Viewing 0 posts

You must be logged in to reply to this topic. Login to reply