What account does the SQL Agent run under and does that account have the appropriate share permissions to write files?

Thank you for responding Michael. I am on SP2 rel 9.00.3042. The data veiwer is on the constraint from SCD Transform object to Insert Destination. The source...

Thanks for all the suggestions!  I have tried the URL.  Works to a certain extent, it does put the fields in separate columns, however, the rows (which are really data...

In order to retreive and display data from MSAS , you must write MDX to create your datasets.  Then it works similar to a report written against a relational database in...

I accomplished this task by using the Reporting Services data driven subscription feature.  High level steps include:

1.  Create your report(even if it just consists of a graph) using the report designer...

Thanks for the suggestion, I got pulled off task.  I am using 8.0.760.   Anyway, it is fixed now. 

Thanks again

Thank you so much for your input. I ended up leaving off the DAY table when I built the time dimension and everything worked as it should. Apparently the data in...

Hi Keith,

Basically, it looks like AS is creating an invalid join between my fact table and my time dimension.

The spec of my time diminsion is 4 main tables.  Year,...

Strange because they see 1 user tables, 2 views  and two sys table.  As if permission was specifically given on those objects. I am not sure about sp_who, but I will check. ...

Thanks for all your suggestions.  The one that I tried was Stacenic's suggestion.  Since it worked, I haven't tried the others but thanks again for your help!!

oops! Sorry, forgot that bit !! Always good practice to destroy the object when done.

Hi There,

Use the file scripting object in an ActiveX Task to delete your file after your import step is successful.

Function Main()

    dim oFSO

'  instantiate the Scripting Object

    set oFSO =...

Hi,

I actually ended up reinstalling Analysis Services, which was probably overkill, but  I just could absolutely not get the databases to show up in Analysis Manager.  Not sure why.  Anyway,...

Actually, I feel like a complete idiot, but basically what happened was that I had to do a restore of the OLAPRepository and the restore copy was not current and did...

Won't an ORDER BY uploaddate DESC work?