Who could help me do these two sample reports for the OLAP Describe two sample r

Question

Who could help me do these two sample reports for the OLAP

Describe two sample reports (Specificy Column, Rows, Filters and Cell values) that can be created using the new schema that addresses the following questions

1) How do sales vary across stores with varying cloud cover during the hours of 8:00am – 4:00pm and Months of May – Sep.

2) How do sales vary across products with varying temperatures during the hours of 12:00pm – 5:00pm during the months of March – Sep.

Here's the format

Sample Report for XXXXX

Report name

Report description

OLAP Report Column Labels

OLAP Report Row Labels

Report Filters

OLAP Report Cell Values

Sample Report for XXXXX

Report name

Report description

OLAP Report Column Labels

OLAP Report Row Labels

Report Filters

OLAP Report Cell Values

Explanation / Answer

1)

Report name

Sales-Month to sep

Report description

The report tries to capture essential role played by weather in achieving sales within the prescribed time frame

OLAP Report Column Labels

OLAP Report Row Labels

Report Filters

Quantity and Month

OLAP Report Cell Values

2)

Report name

Sales-Month to sep

Report description

The report tries to capture essential role played by weather & temperature in achieving sales within the prescribed time frame

OLAP Report Column Labels

OLAP Report Row Labels

Report Filters

Quantity and Month

OLAP Report Cell Values

Month Time Weather Quantity for Sales May 8:00 Cloud cover 10 May 4:00 Cloud cover 10 Sep 4:00 Cloud cover 20 Sep 5:00 Cloud cover 40

Related Questions

Navigate

• Browse (All)
• Browse W
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.