|
Home > Archive > Commerce Server General > August 2005 > Most or Least viewed products report
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
Most or Least viewed products report
|
|
| csstarter 2005-08-16, 8:48 pm |
| Hello ,
Iam trying to generate Most or Least viewed products report from CS
2002 FP1.If anyone could help me I will greatly appreciate that.
Iam pretty sure IIS log hold info abt each product viewed but once i
run the DTS package Iam unable to find where it stores the
information in the Datawarehouse db...
Most of the fields are binary does anyone know how to retrieve this
data into the reports,SQL query report didnt help...may be iam doing
something wrong iam not sure....
Any help will be greatly appeciated.
| |
| Brian Blum [MSFT] 2005-08-17, 5:57 pm |
| Does the 'Top Requested Pages' report not give you what you're looking for
(at least as far as most popular pages go)?
--------------------
NNTP-Posting-Date: Tue, 16 Aug 2005 19:43:07 -0500
Subject: Most or Least viewed products report
From: rayeesur@gmail-dot-com.no-spam.invalid (csstarter)
Newsgroups: microsoft.public.commerceserver.general
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: 8bit
User-Agent: newsSync (Commerce Server) 6647
Message-ID: <nM6dnf11aO2GFZ_eRVn_vQ@giganews.com>
Date: Tue, 16 Aug 2005 19:43:07 -0500
Lines: 1
X-Trace:
sv3- vkppG1at9LgL8GVPwouKYWZS7RBTyJB3acSOifve
naiDLS5mv89vjkIUoJ8dhL/5r0i+0AAo
yyjIpl6!M65OEveLqiwFi4YTJOxlqYg57cZczBdt
OnnuXaH/okap340zXMLkcw+keacL
X-Complaints-To: abuse@giganews.com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your
complaint properly
X-Postfilter: 1.3.32
Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGP08.phx.gbl!newsfeed00.sul.t-online.de!t-onli
ne.de!border2.nntp.dca.giganews.com!nntp.giganews.com!border1.nntp.dca.gigan
ews.com!local01.nntp.dca.giganews.com!news.giganews.com.POSTED!not-for-mail
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:3219
X-Tomcat-NG: microsoft.public.commerceserver.general
Hello ,
Iam trying to generate Most or Least viewed products report from CS
2002 FP1.If anyone could help me I will greatly appreciate that.
Iam pretty sure IIS log hold info abt each product viewed but once i
run the DTS package Iam unable to find where it stores the
information in the Datawarehouse db...
Most of the fields are binary does anyone know how to retrieve this
data into the reports,SQL query report didnt help...may be iam doing
something wrong iam not sure....
Any help will be greatly appeciated.
This posting is provided "AS IS" with no warranties, and confers no rights.
EBusiness Server Team
| |
| csstarter 2005-08-24, 8:51 pm |
| Top requested pages gives in general all the pages visited in the
website....i need the top viewed product pages...any help on this
please....or guide me to a article or any resource whicih will tell
the best way to capture iis logs
| |
| Brian Blum [MSFT] 2005-08-26, 5:56 pm |
| If you don't care about the hits for non product pages, you could filter
those out of the iis logs and then just use the CS Log import and reporting
process.
Otherwise, you can create a custom dimension in the Analysis DB that is
similar to the Uri dimension, but populate it with a view on the
RequestByUri table that only pulls the pages you're interested in. Then
you can create a cube like the Page Usage cube and use your custom
dimension.
--------------------
NNTP-Posting-Date: Wed, 24 Aug 2005 19:43:09 -0500
Subject: re:Most or Least viewed products report
From: rayeesur@gmail-dot-com.no-spam.invalid (csstarter)
Newsgroups: microsoft.public.commerceserver.general
Mime-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-15
Content-Transfer-Encoding: 8bit
User-Agent: newsSync (Commerce Server) 6764
References: <nM6dnf11aO2GFZ_eRVn_vQ@giganews.com>
Message-ID: <jsadncSJEYCAiZDeRVn_vA@giganews.com>
Date: Wed, 24 Aug 2005 19:43:09 -0500
Lines: 1
X-Trace:
sv3- cq2LtHDsVwBypsQaYFcWvgceXEQRHOEbVbVRnZ0C
V/KLgcOMbTmGi//kGVVIXQtrD7VUIlLK
qTu4l3t!LKbEQbh+oWep5VxmB3lqFRb6TQ/ROtRnQyKX+Q2CO3m803vLen4NLFiAKkGz
X-Complaints-To: abuse@giganews.com
X-DMCA-Notifications: http://www.giganews.com/info/dmca.html
X-Abuse-and-DMCA-Info: Please be sure to forward a copy of ALL headers
X-Abuse-and-DMCA-Info: Otherwise we will be unable to process your
complaint properly
X-Postfilter: 1.3.32
Path:
TK2MSFTNGXA01.phx.gbl!TK2MSFTNGXA02.phx.gbl!TK2MSFTNGXA03.phx.gbl!TK2MSFTNGP
08.phx.gbl!newsfeed00.sul.t-online.de!t-online.de!border2.nntp.dca.giganews.
com!nntp.giganews.com!border1.nntp.dca.giganews.com!local01.nntp.dca.giganew
s.com!news.giganews.com.POSTED!not-for-mail
Xref: TK2MSFTNGXA01.phx.gbl microsoft.public.commerceserver.general:3292
X-Tomcat-NG: microsoft.public.commerceserver.general
Top requested pages gives in general all the pages visited in the
website....i need the top viewed product pages...any help on this
please....or guide me to a article or any resource whicih will tell
the best way to capture iis logs
This posting is provided "AS IS" with no warranties, and confers no rights.
EBusiness Server Team
|
|
|
|
|