Data with different Granularity

#1

I've had someone tell me that you can view data that goes to different
granularity in one cube if it is a virtual cube. Eg have Actual data
down to daily level and budget at a monthly level.

this doesn't make much sense to me but is it possible?

Cheers

--
Posted via http://dbforums.com

#2

Howard,

Where can I find these properties?

Thanks,
Hari

Quote:

-----Original Message-----
Emily

This is possible possible.

Also, if your Time dimension has days that rollup into
month, and the
dimension has the property "Member With Data" - "Non-leaf
data visible"
option turned on, you can then input data at a month
level.

You may also decide that you want your time dimension
split between year and
month but then you need to consider all the functionality
required for your
solution. For example, are you intending to do time
series analysis.

Regards

Howard Taylor CA(SA)
Business Intelligence Manager
O2OLAP Limited

tel: +44 (0)20 8785 4811
fax: +44 (0)20 8789 1589
mobile: +44 (0)7831 332234

Apply for your free Excel based browser for Microsoft's
Analysis Services at
www.o2olap.com. Budgeting, forecasting and data
collection solutions for
Analysis Services

"Emily" <member32827 (AT) dbforums (DOT) com> wrote in message
news:3093569.1057802403 (AT) dbforums (DOT) com...

I've had someone tell me that you can view data that
goes to different
granularity in one cube if it is a virtual cube. Eg
have Actual data
down to daily level and budget at a monthly level.

this doesn't make much sense to me but is it possible?

Cheers

--
Posted via http://dbforums.com

.

#3

Emily

Sorry, let me clarify the input comment. When you specify the dimension
property detailed what happens is a new member gets created for all the
non-leaf members of the specific dimension. If you have a writeback client
that can update the cube then you can input to these data members of the
non-leaf members. The data members of non-leaf members are in fact leaf
members that rollup to the non-leaf members.

Howard

"Howard Taylor [O2OLAP]" <Howard.Taylor (AT) o2olap (DOT) com> wrote

Quote:

Emily

This is possible possible.

Also, if your Time dimension has days that rollup into month, and the
dimension has the property "Member With Data" - "Non-leaf data visible"
option turned on, you can then input data at a month level.

You may also decide that you want your time dimension split between year
and
month but then you need to consider all the functionality required for
your
solution. For example, are you intending to do time series analysis.

Regards

Howard Taylor CA(SA)
Business Intelligence Manager
O2OLAP Limited

tel: +44 (0)20 8785 4811
fax: +44 (0)20 8789 1589
mobile: +44 (0)7831 332234

Apply for your free Excel based browser for Microsoft's Analysis Services
at
www.o2olap.com. Budgeting, forecasting and data collection solutions for
Analysis Services

"Emily" <member32827 (AT) dbforums (DOT) com> wrote in message
news:3093569.1057802403 (AT) dbforums (DOT) com...

I've had someone tell me that you can view data that goes to different
granularity in one cube if it is a virtual cube. Eg have Actual data
down to daily level and budget at a monthly level.

this doesn't make much sense to me but is it possible?

Cheers

--
Posted via http://dbforums.com

#4

Hari

On a parent-child dimension find this on the advanced tab of the dimension
properties through the dimension editor.

What does your company do? I believe you are from the somewhere in the
Emirates?

Howard

"Hari" <harihcl (AT) hotmail (DOT) com> wrote

Quote:

Howard,

Where can I find these properties?

Thanks,
Hari
-----Original Message-----
Emily

This is possible possible.

Also, if your Time dimension has days that rollup into
month, and the
dimension has the property "Member With Data" - "Non-leaf
data visible"
option turned on, you can then input data at a month
level.

You may also decide that you want your time dimension
split between year and
month but then you need to consider all the functionality
required for your
solution. For example, are you intending to do time
series analysis.

Regards

Howard Taylor CA(SA)
Business Intelligence Manager
O2OLAP Limited

tel: +44 (0)20 8785 4811
fax: +44 (0)20 8789 1589
mobile: +44 (0)7831 332234

Apply for your free Excel based browser for Microsoft's
Analysis Services at
www.o2olap.com. Budgeting, forecasting and data
collection solutions for
Analysis Services

"Emily" <member32827 (AT) dbforums (DOT) com> wrote in message
news:3093569.1057802403 (AT) dbforums (DOT) com...

I've had someone tell me that you can view data that
goes to different
granularity in one cube if it is a virtual cube. Eg
have Actual data
down to daily level and budget at a monthly level.

this doesn't make much sense to me but is it possible?

Cheers

--
Posted via http://dbforums.com

.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Data with different Granularity

microsoft.public.sqlserver.olap microsoft.public.sqlserver.olap

Data with different Granularity - 07-09-2003 , 09:00 PM

Re: Data with different Granularity - 07-10-2003 , 12:10 AM

Re: Data with different Granularity - 07-10-2003 , 12:18 AM

Re: Data with different Granularity - 07-10-2003 , 04:05 AM