August 19, 2005 at 6:58 am
When we are using more than 10 columns in cube operator it is throwing error that maxiimum limit is 10.
but it is mandatory for my project to use more than 10 columns.
So could any one tell how to do this.
If not at all possible by using cube operator how else can this be done to get the same result
August 21, 2005 at 6:34 am
unfortunately the limitation of the cube operator is 10 dimensions...
maybe you could split it into a couple of views and then query the views...but then if you have a large resultset, this could take "forever"..
if you post your query, someone should be able to give you suggestions!
ps:how many columns & rows are we talking about anyway ?!
**ASCII stupid question, get a stupid ANSI !!!**
August 21, 2005 at 10:55 pm
Thanx sushila.
I may be using zround 18 columns.
the number of rows in 6 columns will be around 4.
in the remaining the number of rows will be more than 8.
As you said by splitting in to views how can we get all the possible combinations of these two views.
If possible could you help in this.
August 22, 2005 at 4:38 am
sai - why don't you post your query and the requirements ?! That should help someone identify a solution much quicker!
**ASCII stupid question, get a stupid ANSI !!!**
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply