Partial Listing of Information

[richbrooks]

I am kind of new to BO and here is what I am trying to do...
.
the way that the dates are set up in the universe is fiscal year, fiscal month and fiscal week and what I am trying to do is show the prior YTD along side of the current YTD. in the query I have extracted Fiscal Year and Fiscal Month (to calculate the YTD).
.
is it possible to assign a quiry to a variable? IE create a variable called YTD 2001 and then assign a Query to it?

Thank you in advance for your help and/or comments....

Rich Brooks

 

[PAULSGS]

You could create an - OBJECT - called YTD 2001 and this would have the effect you want.


The object would be defined as

FiscalYear + FiscalMonth

Which would produce an aggregation of the two values,


Or you could create a Report variable which adds together the two separate Objects's value.

 

[blom0344]

Hello Richbrooks,

Since I'm developing a whole set of reports that show salesrevenues from current fiscal year and fiscal year 2001 I want to comment a bit on PAULSGS's reply:

Creating objects at universe level with restricting 'where' clauses (like YTD2001) will only have use if you split the query into seperate ones for each year and link the dimensions again on report level. This is caused by the nature of SQL, in 1 query extracting data both YTD 2002 and YTD 2001 will result in an SQL with 'where' clauses an empty intersect.

So, if the data in your source is in datasets (each dataset a specific month) and you want to use one query you will have to specify report variables. For YTD figures over 2 years a way around this is to use a dataprovider for each year (BO will automatically link the data over common dimensions , as if making a full outer join) For YTD you do not need local variables ,cause with the right query conditions the sum of query output is the YTD.

In a table you use a column to show the first YTD and in the second column the second YTD. T. Blom
Information analist
Shimano Europe
tbl@shimano-eu.com

 

[richbrooks]

Thanks for the Help....The object suggestion is a good one however, because of the nature of the warehouse we cannot add objects to it. The reason is that we are a global company with numberous divisions. Corporate has maindated that we use a common set of obects which limits what we can do.....

However, based on the suggestions I have come up with another way to do it....take the origional report copy it and then create a sub query based on the orional query....then sum up the fiscal months that I am looking at .....it worked perfectically.....

Thank you for your input it help me with a conclusion..

RB