|
Home > Archive > MS SQL Server OLAP > April 2005 > CellSetGrid
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
| Satya Bojanapally 2005-04-26, 7:23 am |
| Hi Richard,
I am getting an error "Formula error - syntax error - token is not
valid:" when DrillDown a specific dimension. The basic problem may be
like retriving a large amount of data at the time of creating a
namedset.
1). CREATE SET [Equipment].cst_1_4 AS '[Equipment].levels(0).members'
=== Execution successful
2). CREATE SET [Equipment].cst_1_5 AS 'cst_1_4 * [Equipment
Center].levels(0).members'
=== Execution successful
3). CREATE SET [Equipment].cst_1_6 AS
'Hierarchize(Generat
e(cst_1_5,StrToSet(I
IF(Extract({cst_1_5. Current},[Equipment]
).item(0)
IS ([Equipment].[All Equipment]),SetToStr
({Union({[Equipment]
.[All
Equipment]},[Equipme
nt].[All Equipment].Children) *
Extract({cst_1_5.Current},[Equipment
Center])}),SetToStr(
{cst_1_5.Current})))))'
=== Execution Unsuccessful
Throwing an error of "Formula error - syntax error - token is not
valid:".
Please help me in this.
Regards,
satya
| |
| Richard Tkachuk [MSFT] 2005-04-27, 1:23 pm |
| Hi Satya,
Can you download the latest version? I beleive I've addressed this issue.
Regards,
Richard
--
_______________
Disclaimer : This posting is provided "AS IS" with no warranties, and
confers no rights.
"Satya Bojanapally" <satyam88264@gmail.com> wrote in message
news:1114511917.657932.158990@g14g2000cwa.googlegroups.com...
> Hi Richard,
>
> I am getting an error "Formula error - syntax error - token is not
> valid:" when DrillDown a specific dimension. The basic problem may be
> like retriving a large amount of data at the time of creating a
> namedset.
>
> 1). CREATE SET [Equipment].cst_1_4 AS '[Equipment].levels(0).members'
> === Execution successful
>
> 2). CREATE SET [Equipment].cst_1_5 AS 'cst_1_4 * [Equipment
> Center].levels(0).members'
> === Execution successful
>
> 3). CREATE SET [Equipment].cst_1_6 AS
> 'Hierarchize(Generat
e(cst_1_5,StrToSet(I
IF(Extract({cst_1_5. Current},[Equipment]
).item(0)
> IS ([Equipment].[All Equipment]),SetToStr
({Union({[Equipment]
.[All
> Equipment]},[Equipme
nt].[All Equipment].Children) *
> Extract({cst_1_5.Current},[Equipment
> Center])}),SetToStr(
{cst_1_5.Current})))))'
> === Execution Unsuccessful
> Throwing an error of "Formula error - syntax error - token is not
> valid:".
>
> Please help me in this.
>
> Regards,
> satya
>
| |
| Satya Bojanapally 2005-04-28, 3:24 am |
| Hi Richard,
Thank you. The problem was resolved. The Data Area is shrinking when we
add the more Dimensions on the Row Area. If the total report control is
scrolled horizontally would be best instead of only the Data Area.
So that I can see whole rendered report on shot, now I have to scroll
both vertically and horizontally. As you gave a release on the March 6
, 2005. with fixed FieldList.
Can I get update of this.
Regards,
Satya
| |
|
|
|
|
|