phalgunájx.�جrë,Š‰ìš+¢ÊµÊ&

Hi, need desperate help on the approach for the reports as described below:

1. Overview Dashboard report:
Requirement: Need to show a summary of all the reports that we have in our
system (about 10 of them for now). Need graphical representation of all these
in one report.

Scenario:

- We are using many different cubes to display the different reports.

- We do understand that the commerce server report interface
doesn’t show more than one graph and can get data only from one cube or
sql/mdx query.


2. Search engine with Search Phrase report:
Requirement: It needs to identify the top search phrases that led the most
visitors to the site.

Scenario:

- We know that there is no default way of extracting this in MS
Commerce Server.

- We can probably extract this from the query string. But the
problem is that different search engines have their query strings formatted
in different way with different keys as shown in the example below:

- http://www.google.co.in/search?hl=en&q=eastman+chemicals&meta=

-
http://search.yahoo.com/search?p=eastman+chemicals&sm=Yahoo%21+Search&fr=FP-tab-web-t&toggle=1&ei=UTF-8


Question: Please suggest an approach and a practical way of implementing
these reports.
any pointers are welcome
--
TIA
Phalgun Babu

brianbl

I don't understand your Dashboard requirement, so I can't comment on that.

For your query string report, you should be able to derive a report based
on the Single Value Query string report. You would want to modify the SQL
queries to filter based on the URI of the search engine.
--------------------
Thread-Topic: 'Search phrase' and 'Dashboard' report
thread-index: AcUTKDJcsXPkn5vdS4CZIFllAdfbww==
X-WBNR-Posting-Host: 220.227.179.5
From: "=?Utf-8?B?UGhhbGd1bg==?=" <Phalgun@discussions.microsoft.com>
Subject: 'Search phrase' and 'Dashboard' report
Date: Mon, 14 Feb 2005 22:33:01 -0800
Lines: 41
Message-ID: <8E6D8D10-FA6D-4BB6-BD4F-1EC3A5E9537D@microsoft.com>
MIME-Version: 1.0
Content-Type: text/plain;
charset="Utf-8"
Content-Transfer-Encoding: 8bit
X-Newsreader: Microsoft CDO for Windows 2000
Content-Class: urn:content-classes:message
Importance: normal
Priority: normal
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.0
Newsgroups: microsoft.public.commerceserver.****ysis
NNTP-Posting-Host: TK2MSFTNGXA03.phx.gbl 10.40.1.29
Path: TK2MSFTNGXA01.phx.gbl!cpmsftngxa10.phx.gbl!TK2MSFT NGXA03.phx.gbl
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.****ysis:358
X-Tomcat-NG: microsoft.public.commerceserver.****ysis

Hi, need desperate help on the approach for the reports as described below:

1. Overview Dashboard report:
Requirement: Need to show a summary of all the reports that we have in our
system (about 10 of them for now). Need graphical representation of all
these
in one report.

Scenario:

- We are using many different cubes to display the different
reports.

- We do understand that the commerce server report interface
doesn’t show more than one graph and can get data only from one cube or
sql/mdx query.


2. Search engine with Search Phrase report:
Requirement: It needs to identify the top search phrases that led the most
visitors to the site.

Scenario:

- We know that there is no default way of extracting this in MS
Commerce Server.

- We can probably extract this from the query string. But the
problem is that different search engines have their query strings formatted
in different way with different keys as shown in the example below:

- http://www.google.co.in/search?hl=en&q=eastman+chemicals&meta=

-
http://search.yahoo.com/search?p=eastman+chemicals&sm=Yahoo%21+Search&fr=FP-
tab-web-t&toggle=1&ei=UTF-8


Question: Please suggest an approach and a practical way of implementing
these reports.
any pointers are welcome
--
TIA
Phalgun Babu


This posting is provided "AS IS" with no warranties, and confers no rights.

EBusiness Server Team