|Re: Chart Report For Work Schedules [message #794801 is a reply to message #794348]
||Thu, 09 February 2012 18:07
| Jason Weathersby
Registered: July 2009
You can use multiple datasets in a cube as long as they have some kind |
of link to the primary dataset. If you use a date time dimension it has
some predefined levels like, month, quarter, and year.
On the second question: The sum will be dependent on the dimension
resolution. If you are rolling up by day then you will get the data
value for the day. If the dimension is rolling up by month then you
will get the month value. So if you want to show it as it is, use the
dimension level resolution of the data. BTW here is a post that has
some cube info and an article you can look at. It also has some
On 2/9/2012 2:14 AM, Jacob Jacob wrote:
> Thanks Jason for your replies.
> I am trying to follow this example
> In the example category 0 10000
> 10000 20000
> 20000 30000
> >= 30000
> is one of the dimension. For my requirement I need to have a similar
> date range starting from Jan-2011 to Dec-2011 as one of the dimension.
> For this is it possible to have a separate query to get this data?
> Another question is in summary field how can I show data as it is, I can
> only choose one of the function like count,sum, max,min etc.
> What if I do not want to use any function, use data as it is?
Powered by FUDForum
. Page generated in 0.02652 seconds