Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations dencom on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
GP discounts, freights data in SOP tables
Hi, Could someone please direct to the table names and column names where discounts, freights and other SOP header information is stored. Thank you very much Roman- rkiss
- Thread
- Replies: 3
- Forum: Microsoft: Dynamics GP (Great Plains)
-
Automated Cube Refresh - Cognos 8BI
Hi, Does anyone have a solution to the following issue: Issue: Daily Automated Cube Refresh in Cognos 8 BI. Current issues/points: 1. It looks like you cannot over-ride a cube file if there is an open Cognos 8BI session... 2. How do you force to kill all open sessions in order to over ride...- rkiss
- Thread
- Replies: 5
- Forum: Cognos solutions
-
Date Functions
Hi, I would like to know the equivalent Cognos 8BI expression for the following MS SQL query: SELECT convert(varchar(10), dateadd(d, 1 - datepart(w, getdate()), getdate()), 101) AS last_sunday The above sql query will return the date of last Sunday on any given day of the week. Thank...- rkiss
- Thread
- Replies: 1
- Forum: Cognos solutions
-
Metadata Model for use in Analysis and Report Studio
Hi, I just can't figure it out how Framework Manager dimensional modeling works. I mean, I understand the concept of dimensional modeling, but I think I read too many manuals and I got confused.. here is my very very simple scenario....I need to use this model in Analysis and Report Studio...- rkiss
- Thread
- Replies: 0
- Forum: Cognos solutions
