| Author |
Message |
csstarter
Guest
|
 Posted:
Wed Aug 17, 2005 12:51 am Post subject:
Most or Least viewed products report |
|
|
Hello ,
Iam trying to generate Most or Least viewed products report from C
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
run the DTS package Iam unable to find where it stores th
information in the Datawarehouse db..
Most of the fields are binary does anyone know how to retrieve thi
data into the reports,SQL query report didnt help...may be iam doin
something wrong iam not sure...
Any help will be greatly appeciated |
|
| Back to top |
|
 |
Brian Blum [MSFT]
Guest
|
| Posted:
Wed Aug 17, 2005 8:52 pm Post subject:
RE: Most or Least viewed products report |
|
|
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-vkppG1at9LgL8GVPwouKYWZS7RBTyJB3acSOifvenaiDLS5mv89vjkIUoJ8dhL/5r0i+0AAo
yyjIpl6!M65OEveLqiwFi4YTJOxlqYg57cZczBdtOnnuXaH/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 |
|
| Back to top |
|
|
csstarter
Guest
|
| Posted:
Thu Aug 25, 2005 12:52 am Post subject:
re:Most or Least viewed products report |
|
|
Top requested pages gives in general all the pages visited in th
website....i need the top viewed product pages...any help on thi
please....or guide me to a article or any resource whicih will tel
the best way to capture iis log |
|
| Back to top |
|
|
Brian Blum [MSFT]
Guest
|
| Posted:
Fri Aug 26, 2005 4:52 pm Post subject:
re:Most or Least viewed products report |
|
|
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-cq2LtHDsVwBypsQaYFcWvgceXEQRHOEbVbVRnZ0CV/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 |
|
| Back to top |
|
|
|
|
|
|
FAQ
Memberlist
Register
Profile
Log in to check your private messages
Log in