YetAnotherForum
Welcome Guest Search | Active Topics | Log In | Register

PI OLEDB using SSRS query Designer Options · View
Previous Topic · Next Topic
alomairs
#1 Posted : Wednesday, January 04, 2012 7:57:49 AM
Rank: Newbie
Groups: Member

Joined: 1/25/2011
Posts: 8
Location: Oman
Hi All,

Am trying to retrieve data from picomp2, but I can’t find a way to obtain just a single value for that day, I mean a daily value (single).
i.e. if I use piinterp2 I would be able to use the timestep = ‘1d’, but in picomp2 there isn’t timestepSad .

I don’t want to use piinterp2 as the figures that am getting doesn’t match with what am looking for.

Thanks and Regards
Saud
Back to top
 Report Abusive | Report SPAM
Sponsor  
 

OSIsoft vCampus is a subscription-based, online offering that consists of providing everything people need to develop applications on the PI System.
We invite you to take a "tour" of the OSIsoft Virtual Campus - also feel free to consult the FAQ  or contact OSIsoft vCampus for more details.
Back to top  
squatty
#2 Posted : Wednesday, January 04, 2012 8:21:38 AM
Rank: Advanced Member

Groups: Member

Joined: 4/7/2011
Posts: 137
Location: KZN, South Africa
Do you want averages,total.....you can't just have one values as there could be thousands in a day per tag.

picomp2 will give you compressed data
pimean will give you averages

please refer to your pi-oledb documentation as they give you an explanation of each table.
Back to top
 Report Abusive | Report SPAM
Users browsing this topic
Guest
Forum Jump  
You cannot post new topics in this forum.
You cannot reply to topics in this forum.
You cannot delete your posts in this forum.
You cannot edit your posts in this forum.
You cannot create polls in this forum.
You cannot vote in polls in this forum.

YAFVision Theme by Jaben Cargman (Tiny Gecko)
Powered by YAF | YAF © 2003-2008, Yet Another Forum.NET