Hi

Ran the setup once again and install an addition Analysis Services in Tabular mode.

Got a bit confused as to how to connect to it initially but now working fine.

Thanks!!

Hi

Thanks for this solution which works fine.

Having said that, it only works if the Data Range is specified in the SELECT part of the query.

If I put the Range in...

I have finally solve my first problem!

The solution is very easy in the end:

WebClient wc = new WebClient();

wc.DownloadFile(<dropbox file>, <destination file>);

... and that's it!!

The dropbox file must be in the...

Ok, thanks.

I'll give it a go.

I have done quite a lot of Scripts in C# so it shouldn't be to hard ... I hope.

Cheers

Hi

Thanks for the info but I have already tried with xx.xx.xx.xx:2383 an go the same result.

Cheers

Hi Paul

I managed to do it by using the Properties. Instead of using the "Site Id" I have used the Id which is the Key and called the "Location" Property.

Thanks...

Hi

Sorry to reply to my own post but I have found a solution.

In my query, instead of using the usual @Param, replace any variable by ? and map them in...

We're moving to the Cloud so the Users will change Domain, ... that's the reason behind updating the SID.

I'll have a look at the Catalog Table.

Our Server is configure the...

As the Users have new login on the new Server I have updated their SID in the dbo.Users Table using the SUSER_SID function.

When I connect to http://<server>/Reports and...

Hi

I did indeed.

Following the restore of both Databases I have

- deleted the encryption via the configuration tool

- restore the encryption key via...

Smashing thanks!

Ludo

Hi

Thanks for the info. I will have a look at what is generated and see if we can implement a solution around it.

Cheers

Ludo

George

It's a long story of having to keep old huge Databases and going Live on a new one so a lot of the disks were used. This exercise was to...

George

We have backups running every night so I had a 1 day old one. The issue is that we didn't want to loose 1 day of business.

Before the delete of...

Hi

Thanks for replying.

I managed to find a solution which is not documented anywhere as far as I could see.

Here is my method assuming that you had initialy 5 filegroups and...