Search results for query: *

Hi Adionne, Would you happen to know the field names for the following items in the database - Discounts - Freight - Miscellaneous charges Thank you, Roman

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

Hi MF, Your solution is similar to our solution... We have one macro file where we detect the day (even or odd number) of the week. If it is an even number, the macro will build the cube to "Even Number" folder on the same server and using the CubeSwap utility, we will replace the current...

Thank you for your reply... Well,... Your solution would probably work in a medium size company....We are a global,5000 employee corporation....therefore...we cannot take the gable that no one will be using the application...Restarting Services would take anywhere between 1 - 3 minutes...that...

Hi, I never experienced issue 1 or 2 with MR2 upgrade...However, issue 3 is a known issue in our company...have logged a case against this issue... Thanks Roman

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...

Here is the answer: _add_days(current_date,-1*(_day_of_week(current_date,8)))

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...

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...