SAS Office Analytics, SAS Add-In for Microsoft Office, and other integrations

Using excel to access SAS OLAP cubes

Super Contributor
Posts: 275

Using excel to access SAS OLAP cubes

I am using excel and my users want a predesigned excelsheet with the most common choises already there.
I make the sheet and check "refresh on open" and uncheck "save password", and finally saves it to disc.

The problem occur when a user (or anyone) open the excelfile, they get prompted to log in, but if they choose to cancel they come to excel with the figures that was saved by me.

I want the figures to be blanked or not displayed until the user logs in.

Do anyone have a solution/work around for this?
SAS Employee
Posts: 44

Re: Using excel to access SAS OLAP cubes

In the current design, if the refresh is aborted for any reason before results are retrieved, the current contents of the document are not cleared.

The only suggestion I have as a work around would be to write a bit of VBA code to clear the portion of the document when it is opened by the user.
Ask a Question
Discussion stats
  • 1 reply
  • 2 in conversation