Mixing Aggregated data with non-aggregated data in a cube.

At this stage in the project I have a simple fact table which currently holds the low level data. I have designed and built a cube around this table and everything works fine with the current data.

The next stage of the project is to migrate some data into the cube from another business area. The problem is that this data is already grouped. I would like to display this data in the same cube so the users can at least get an overview of the different business areas. Is this practical and doable or are there caveats to doing this?

Does anyone have any suggestions as to what the best approach would be?

The classic approach to this problem is to create another measure group for the new set of data, and set the granularity of that measure group to match the granularity of data. I.e., if in the original measure group, the granularity by Time was Day, in the new one it might be set to Month. Some dimensions may be missing from the new measure group altogether etc.

Mosha.

|||

Interesting.... so is this what I need to do..(an educated guess):

Add the data to the same table|||

Since data is at different granularities - I suggest you keep it in different tables, not in the same table.

Once everything is done - you will be able to use your cube from Excel pivot tables or any other client tool. You will have multiple measures, some of them at one granularity and some at another.

Missing something simple

I have a new sever for our "stage" systems. This box is also the box used
for all backups. I can't seem to establish it for use in a maintenance
plan? Says that the server/location doesn't exist. " Device Error or
Device Offline. "
Is there a permissions seting that Ihave to set on this new box, or is there
some other reason?
\\StageSQL2 is server
\Database Backups\TGISQL\Data\ is folder for all db's and the db will have
it's sub_folder.
any ideas?
Stephen,
Ensure the Windows domain user account that the SQL Server Agent service is
running under has the appropriate permissions to write the backup files to
the share on your remote backup server.
HTH
Jerry
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:OjfcNuhuFHA.4032@.TK2MSFTNGP15.phx.gbl...
>I have a new sever for our "stage" systems. This box is also the box used
>for all backups. I can't seem to establish it for use in a maintenance
>plan? Says that the server/location doesn't exist. " Device Error or
>Device Offline. "
> Is there a permissions seting that Ihave to set on this new box, or is
> there some other reason?
> \\StageSQL2 is server
> \Database Backups\TGISQL\Data\ is folder for all db's and the db will
> have it's sub_folder.
> any ideas?
>
|||HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/default...b;en-us;555128
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:OjfcNuhuFHA.4032@.TK2MSFTNGP15.phx.gbl...
>I have a new sever for our "stage" systems. This box is also the box used
>for all backups. I can't seem to establish it for use in a maintenance
>plan? Says that the server/location doesn't exist. " Device Error or
>Device Offline. "
> Is there a permissions seting that Ihave to set on this new box, or is
> there some other reason?
> \\StageSQL2 is server
> \Database Backups\TGISQL\Data\ is folder for all db's and the db will
> have it's sub_folder.
> any ideas?
>
|||"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:O$h3Z8huFHA.2072@.TK2MSFTNGP14.phx.gbl...
> HowTo: Backup to UNC name using Database Maintenance Wizard
> http://support.microsoft.com/default...b;en-us;555128
>
Thanks. I had to do what it said and then share the folder to get a backup
to actually work. Don't like the share idea but it's working for now.
|||You can always apply NTFS permissions to the underlying file structure and
restrict it down as tight as you like. The SQL service account will always
need FULL ACCESS, but you can deny anyone else access.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:%23HOFkMiuFHA.3752@.TK2MSFTNGP09.phx.gbl...
> "Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
> news:O$h3Z8huFHA.2072@.TK2MSFTNGP14.phx.gbl...
> Thanks. I had to do what it said and then share the folder to get a
> backup to actually work. Don't like the share idea but it's working for
> now.
>

Missing something simple

I have a new sever for our "stage" systems. This box is also the box used
for all backups. I can't seem to establish it for use in a maintenance
plan? Says that the server/location doesn't exist. " Device Error or
Device Offline. "
Is there a permissions seting that Ihave to set on this new box, or is there
some other reason?
\\StageSQL2 is server
\Database Backups\TGISQL\Data\ is folder for all db's and the db will have
it's sub_folder.
any ideas?Stephen,
Ensure the Windows domain user account that the SQL Server Agent service is
running under has the appropriate permissions to write the backup files to
the share on your remote backup server.
HTH
Jerry
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:OjfcNuhuFHA.4032@.TK2MSFTNGP15.phx.gbl...
>I have a new sever for our "stage" systems. This box is also the box used
>for all backups. I can't seem to establish it for use in a maintenance
>plan? Says that the server/location doesn't exist. " Device Error or
>Device Offline. "
> Is there a permissions seting that Ihave to set on this new box, or is
> there some other reason?
> \\StageSQL2 is server
> \Database Backups\TGISQL\Data\ is folder for all db's and the db will
> have it's sub_folder.
> any ideas?
>|||HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/defaul...kb;en-us;555128
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:OjfcNuhuFHA.4032@.TK2MSFTNGP15.phx.gbl...
>I have a new sever for our "stage" systems. This box is also the box used
>for all backups. I can't seem to establish it for use in a maintenance
>plan? Says that the server/location doesn't exist. " Device Error or
>Device Offline. "
> Is there a permissions seting that Ihave to set on this new box, or is
> there some other reason?
> \\StageSQL2 is server
> \Database Backups\TGISQL\Data\ is folder for all db's and the db will
> have it's sub_folder.
> any ideas?
>|||"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:O$h3Z8huFHA.2072@.TK2MSFTNGP14.phx.gbl...
> HowTo: Backup to UNC name using Database Maintenance Wizard
> http://support.microsoft.com/defaul...kb;en-us;555128
>
Thanks. I had to do what it said and then share the folder to get a backup
to actually work. Don't like the share idea but it's working for now.|||You can always apply NTFS permissions to the underlying file structure and
restrict it down as tight as you like. The SQL service account will always
need FULL ACCESS, but you can deny anyone else access.
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:%23HOFkMiuFHA.3752@.TK2MSFTNGP09.phx.gbl...
> "Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
> news:O$h3Z8huFHA.2072@.TK2MSFTNGP14.phx.gbl...
> Thanks. I had to do what it said and then share the folder to get a
> backup to actually work. Don't like the share idea but it's working for
> now.
>

Missing something simple

I have a new sever for our "stage" systems. This box is also the box used
for all backups. I can't seem to establish it for use in a maintenance
plan? Says that the server/location doesn't exist. " Device Error or
Device Offline. "
Is there a permissions seting that Ihave to set on this new box, or is there
some other reason?
\\StageSQL2 is server
\Database Backups\TGISQL\Data\ is folder for all db's and the db will have
it's sub_folder.
any ideas?Stephen,
Ensure the Windows domain user account that the SQL Server Agent service is
running under has the appropriate permissions to write the backup files to
the share on your remote backup server.
HTH
Jerry
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:OjfcNuhuFHA.4032@.TK2MSFTNGP15.phx.gbl...
>I have a new sever for our "stage" systems. This box is also the box used
>for all backups. I can't seem to establish it for use in a maintenance
>plan? Says that the server/location doesn't exist. " Device Error or
>Device Offline. "
> Is there a permissions seting that Ihave to set on this new box, or is
> there some other reason?
> \\StageSQL2 is server
> \Database Backups\TGISQL\Data\ is folder for all db's and the db will
> have it's sub_folder.
> any ideas?
>|||HowTo: Backup to UNC name using Database Maintenance Wizard
http://support.microsoft.com/default.aspx?scid=kb;en-us;555128
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:OjfcNuhuFHA.4032@.TK2MSFTNGP15.phx.gbl...
>I have a new sever for our "stage" systems. This box is also the box used
>for all backups. I can't seem to establish it for use in a maintenance
>plan? Says that the server/location doesn't exist. " Device Error or
>Device Offline. "
> Is there a permissions seting that Ihave to set on this new box, or is
> there some other reason?
> \\StageSQL2 is server
> \Database Backups\TGISQL\Data\ is folder for all db's and the db will
> have it's sub_folder.
> any ideas?
>|||"Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
news:O$h3Z8huFHA.2072@.TK2MSFTNGP14.phx.gbl...
> HowTo: Backup to UNC name using Database Maintenance Wizard
> http://support.microsoft.com/default.aspx?scid=kb;en-us;555128
>
Thanks. I had to do what it said and then share the folder to get a backup
to actually work. Don't like the share idea but it's working for now.|||You can always apply NTFS permissions to the underlying file structure and
restrict it down as tight as you like. The SQL service account will always
need FULL ACCESS, but you can deny anyone else access.
--
Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP
"Stephen Russell" <srussell@.transactiongraphics.com> wrote in message
news:%23HOFkMiuFHA.3752@.TK2MSFTNGP09.phx.gbl...
> "Geoff N. Hiten" <sqlcraftsman@.gmail.com> wrote in message
> news:O$h3Z8huFHA.2072@.TK2MSFTNGP14.phx.gbl...
>> HowTo: Backup to UNC name using Database Maintenance Wizard
>> http://support.microsoft.com/default.aspx?scid=kb;en-us;555128
> Thanks. I had to do what it said and then share the folder to get a
> backup to actually work. Don't like the share idea but it's working for
> now.
>