Search results for query: *

Hi, I am calculating the running total using the function CUME. I want to reset this runningh total whenever there is change in certain set of keys. Can anybody let me know how to do that ? Atul.

Hi, I am doing a cumulative sum on a particular column and I want to reset the sum by a combination of keys. I am able to reset by a single key but not able to do with a combination of keys. Can anybody have any idea how to reset the cumulative sum by a combination of keys. Atul.

I am trying to load data from flat files into redbrick database using the Redbrick ODBC driver for the target database The session is running. The session log generated shows say 3000 rows inserted for the target but actually inserts a lot less number of rows. It also shows the error message...

I am trying to load data from flat files into redbrick database using the Redbrick ODBC driver for the target database The session is running. The session log generated shows say 3000 rows inserted for the target but actually inserts a lot less number of rows. It also shows the error message...

Hi, I have one model with which I want to generate two powercubes for two different customers. All the data is stored in one single table. For ex. I have two cutomers A & B. And I have 100 records for each customer A & B. I want to generate a cube for customer A & B separately. The dimensions &...

Hi, For a particular record I am getting /0 value in the cube. But there is a non zero value in the database table for that record. Can anybody tell when this value /0 appears in the cube. I mean under what conditions. Atul.

Steve, Yes I have multiple measure IQDs. And all these IQDs are built on one single table. Atul.

I have 10 measures in the PowerPlay cube. When I generate the cube with all the 10 measures, some of the measures values are getting multiplied by 10. But If I have only those measures in the Report which are getting multiplied by 10 and if I generate the cube for a specified period then the...

How do I get the system date as the default date for one of the date variable in the prompt?

1) In the prompt when I enter date it takes in YYYY-MM-DD format. How do I change this format to DD-MM-YYYY 2) How to add our own messages in the prompt for a invalid input. 3) Can we add some text in the bottom of the prompt screen. 4) I am having one crosstab report which contains one main...