Showing posts with label olap. Show all posts
Showing posts with label olap. Show all posts

Sunday, March 25, 2012

Calculated Measure for Sales Data

Hello!

I'm sort of a novice with AS, so you guys may have to bear with me. We have a sales database created in SQL 2000 and OLAP cubes built against it with AS 2000. The cubes contain dimensions of Customers, Products, Calendar, and measure of NetSales. We have numerous other dimensions and measures.

I'm wanting to build a calculated measure for WeeksOnHand. This measure is supposed to only show the items which represent the particular member chosen in the WeeksOnHand measure. For instance, WeeksOnHand would include the following members 1 through 10. Each number represents number of weeks. The number of weeks defines how many weeks a product has been onhand (netsales greater than zero).

So, if I were to filter on Customer A, choose all Products, and choose 2 in the WeeksOnHand measure, it would only show me the products for Customer A which have been onhand for 2 weeks (in other words, sales greater than zero for 2 weeks). It would filter out any products in which sales started occurring longer than 2 weeks, less than 2 weeks, or still zero).

Any help would be appreciated.

Thanks!

Lance

Good Morning Everyone!

No takers?

Calculated Measure for Sales Data

Hello!

I'm sort of a novice with AS, so you guys may have to bear with me. We have a sales database created in SQL 2000 and OLAP cubes built against it with AS 2000. The cubes contain dimensions of Customers, Products, Calendar, and measure of NetSales. We have numerous other dimensions and measures.

I'm wanting to build a calculated measure for WeeksOnHand. This measure is supposed to only show the items which represent the particular member chosen in the WeeksOnHand measure. For instance, WeeksOnHand would include the following members 1 through 10. Each number represents number of weeks. The number of weeks defines how many weeks a product has been onhand (netsales greater than zero).

So, if I were to filter on Customer A, choose all Products, and choose 2 in the WeeksOnHand measure, it would only show me the products for Customer A which have been onhand for 2 weeks (in other words, sales greater than zero for 2 weeks). It would filter out any products in which sales started occurring longer than 2 weeks, less than 2 weeks, or still zero).

Any help would be appreciated.

Thanks!

Lance

Good Morning Everyone!

No takers?

Calculated fields on olap pivottable in excel 2007

Is there a way to add calculated fields in excel 2007 to a pivot table, connected to a SSAS cube?

Meaning that is calculated on the fly automatically while drilling up/down...

I do not think so. The formulas button is disabled. Formulas have to be server side MDX calculated members. Same in Excel 2003

You will also note some other diffences like Grouping may require security access to cube metadata in order to work.

Philippe

|||This is quite a disadvantage! Hopefully the kpi wizard and the set selector of ProClarity will be integrated into excel!

Calculated Fields in an OLAP cube severly impact data retrieval time

I have a OLAP cube that I'm using for a data source that has several
calculated measures in it. When I add the calculated measures to my report
the retrieval time goes from ~1 second to ~4 minutes. I haven't been able
to locate any information about this issue. Is there something I'm doing
wrong, or is this a Reporting services issue?Nevermind. I hadn't realized that splitting a calculated field over an
unrelated dimension would have the same effect.
"Jeremy Farnham" <jeremy.farnham@.omya.com> wrote in message
news:esFYjweBIHA.4712@.TK2MSFTNGP04.phx.gbl...
>I have a OLAP cube that I'm using for a data source that has several
>calculated measures in it. When I add the calculated measures to my report
>the retrieval time goes from ~1 second to ~4 minutes. I haven't been able
>to locate any information about this issue. Is there something I'm doing
>wrong, or is this a Reporting services issue?
>sql