Ok finally figured this out. took a while because i had worked around the issue using SSIS initially but the work involved is a lot more than a simple...

Thought it would of been too obvious (always worth asking the simple questions first though) and sounds like you've tried all variations too.

There always powershell 🙂

here's a link which...

sorry if you've already thought of this but i thought i'd ask the obvious first:

Has the service account got the rights to process the cube?

Try connecting directly to the SSAS...

wicked, will give that a try now

thanks for the help, will let you know how i get on 🙂

Excellent article. This is similar to something i have previously developed whilst working for a company which processes 10 - 1000's of data files daily.

having the information in the...

Cadence

Is this what your looking for:

select distinct @@servername, a.database_name 'DB Name',

convert(decimal(7,2),round(sum(compressed_backup_size/1024/1024/1024),3)) as 'Compressed Database Size in(GB)',

convert(decimal(7,2),round(sum(compressed_backup_size/1024/1024),3)) as 'Compressed Database Size in(MB)'

from msdb..backupset a

inner join msdb..backupfile b on a.backup_set_id =...

hows the source populated. maybe is it being populated when your trying to extract it and its not been posted yet?

as others have posted it depends on what your grouping method is. we can see it has to be 5 day groups,

* so it that every 5 days...

I can see you want to group the days into sets of 5 but before you start dont you need an anchor date.. or will this always be the...

other than excel and BIDS

ive used Sharepoint performance point, not so bad

also SSRS but thats like using BIDS essentially

so if you looking to give users access then i'd...

few ways i can think of, which maybe of help or not:

1. store all times against one specific date so it is a datetime but only ever one

2. break minutes...

Your very welcome.

Glad i could help.

climacteric