I am using cubefunctions against Analysis Services and i follow instructions
in this:

http://office.microsoft.com/download...AM102200231033

When i type in function from page 6 step 8:

=CUBESET("aw",CONCATENATE("DESCENDANTS([Geography].[Geography].[All
Geographies].[",$C$4,"], 2)"),"Top 10 Cities by
Profit",2,"[Measures].[Reseller Gross Profit]")

I get a #N/A error. I am connected to cube and other cube functions work. If
i try changing function to

=CUBESET("adv";"[Geography].[Geography].[All Geographies].[United
Kingdom].[England].children";"Top 10 Cities by Profit";0)

I dont get error and i get data from Analisys Services. Seems like the
complexity of the statement gives trouble.

Screenshoot 1 (working formula)

http://h1.ripway.com/mivar/cubeset1.JPG

Screenshoot 2 (not working formula)

http://h1.ripway.com/mivar/cubeset2.JPG

Solved !!!

In the first was a typo-error - correcting that wasnt enouhg but it was
because in excel i use ";" as separator but in sentence for AS i have to use
","

So sentenced had to be corrected so in the part that goes to AS within "" i
have to use "," as separator.

http://h1.ripway.com/mivar/cubest3.JPG



"michael vardinghus" <xx> skrev i en meddelelse
news:e8zQo1Y6IHA.3816@TK2MSFTNGP03.phx.gbl...
>I am using cubefunctions against Analysis Services and i follow
>instructions in this:
>
> http://office.microsoft.com/download...AM102200231033
>
> When i type in function from page 6 step 8:
>
> =CUBESET("aw",CONCATENATE("DESCENDANTS([Geography].[Geography].[All
> Geographies].[",$C$4,"], 2)"),"Top 10 Cities by
> Profit",2,"[Measures].[Reseller Gross Profit]")
>
> I get a #N/A error. I am connected to cube and other cube functions work.
> If i try changing function to
>
> =CUBESET("adv";"[Geography].[Geography].[All Geographies].[United
> Kingdom].[England].children";"Top 10 Cities by Profit";0)
>
> I dont get error and i get data from Analisys Services. Seems like the
> complexity of the statement gives trouble.
>
> Screenshoot 1 (working formula)
>
> http://h1.ripway.com/mivar/cubeset1.JPG
>
> Screenshoot 2 (not working formula)
>
> http://h1.ripway.com/mivar/cubeset2.JPG
>
>
>
>
>
>

And this is an Excel question?

--
Wigi
http://www.wimgielis.be = Excel/VBA, soccer and music


"michael vardinghus" wrote:

> Solved !!!
>
> In the first was a typo-error - correcting that wasnt enouhg but it was
> because in excel i use ";" as separator but in sentence for AS i have to use
> ","
>
> So sentenced had to be corrected so in the part that goes to AS within "" i
> have to use "," as separator.
>
> http://h1.ripway.com/mivar/cubest3.JPG
>
>
>
> "michael vardinghus" <xx> skrev i en meddelelse
> news:e8zQo1Y6IHA.3816@TK2MSFTNGP03.phx.gbl...
> >I am using cubefunctions against Analysis Services and i follow
> >instructions in this:
> >
> > http://office.microsoft.com/download...AM102200231033
> >
> > When i type in function from page 6 step 8:
> >
> > =CUBESET("aw",CONCATENATE("DESCENDANTS([Geography].[Geography].[All
> > Geographies].[",$C$4,"], 2)"),"Top 10 Cities by
> > Profit",2,"[Measures].[Reseller Gross Profit]")
> >
> > I get a #N/A error. I am connected to cube and other cube functions work.
> > If i try changing function to
> >
> > =CUBESET("adv";"[Geography].[Geography].[All Geographies].[United
> > Kingdom].[England].children";"Top 10 Cities by Profit";0)
> >
> > I dont get error and i get data from Analisys Services. Seems like the
> > complexity of the statement gives trouble.
> >
> > Screenshoot 1 (working formula)
> >
> > http://h1.ripway.com/mivar/cubeset1.JPG
> >
> > Screenshoot 2 (not working formula)
> >
> > http://h1.ripway.com/mivar/cubeset2.JPG
> >
> >
> >
> >
> >
> >
>
>
>

It was an excel questin and answer.

Because you dont know how to get Excel to work with other platforms doesnt
mean that discipline exists.

Did u read my posts at all ?

"Wigi" <Wigi@discussions.microsoft.com> skrev i en meddelelse
news:C952DEA4-3DEA-4137-8D53-CCDBB4EAC34E@microsoft.com...
> And this is an Excel question?
>
> --
> Wigi
> http://www.wimgielis.be = Excel/VBA, soccer and music
>
>
> "michael vardinghus" wrote:
>
>> Solved !!!
>>
>> In the first was a typo-error - correcting that wasnt enouhg but it was
>> because in excel i use ";" as separator but in sentence for AS i have to
>> use
>> ","
>>
>> So sentenced had to be corrected so in the part that goes to AS within ""
>> i
>> have to use "," as separator.
>>
>> http://h1.ripway.com/mivar/cubest3.JPG
>>
>>
>>
>> "michael vardinghus" <xx> skrev i en meddelelse
>> news:e8zQo1Y6IHA.3816@TK2MSFTNGP03.phx.gbl...
>> >I am using cubefunctions against Analysis Services and i follow
>> >instructions in this:
>> >
>> > http://office.microsoft.com/download...AM102200231033
>> >
>> > When i type in function from page 6 step 8:
>> >
>> > =CUBESET("aw",CONCATENATE("DESCENDANTS([Geography].[Geography].[All
>> > Geographies].[",$C$4,"], 2)"),"Top 10 Cities by
>> > Profit",2,"[Measures].[Reseller Gross Profit]")
>> >
>> > I get a #N/A error. I am connected to cube and other cube functions
>> > work.
>> > If i try changing function to
>> >
>> > =CUBESET("adv";"[Geography].[Geography].[All Geographies].[United
>> > Kingdom].[England].children";"Top 10 Cities by Profit";0)
>> >
>> > I dont get error and i get data from Analisys Services. Seems like the
>> > complexity of the statement gives trouble.
>> >
>> > Screenshoot 1 (working formula)
>> >
>> > http://h1.ripway.com/mivar/cubeset1.JPG
>> >
>> > Screenshoot 2 (not working formula)
>> >
>> > http://h1.ripway.com/mivar/cubeset2.JPG
>> >
>> >
>> >
>> >
>> >
>> >
>>
>>
>>

....or even bothered to look at screenshots..


"michael vardinghus" <xx> skrev i en meddelelse
news:uybugOa6IHA.3856@TK2MSFTNGP06.phx.gbl...
> Solved !!!
>
> In the first was a typo-error - correcting that wasnt enouhg but it was
> because in excel i use ";" as separator but in sentence for AS i have to
> use ","
>
> So sentenced had to be corrected so in the part that goes to AS within ""
> i have to use "," as separator.
>
> http://h1.ripway.com/mivar/cubest3.JPG
>
>
>
> "michael vardinghus" <xx> skrev i en meddelelse
> news:e8zQo1Y6IHA.3816@TK2MSFTNGP03.phx.gbl...
>>I am using cubefunctions against Analysis Services and i follow
>>instructions in this:
>>
>> http://office.microsoft.com/download...AM102200231033
>>
>> When i type in function from page 6 step 8:
>>
>> =CUBESET("aw",CONCATENATE("DESCENDANTS([Geography].[Geography].[All
>> Geographies].[",$C$4,"], 2)"),"Top 10 Cities by
>> Profit",2,"[Measures].[Reseller Gross Profit]")
>>
>> I get a #N/A error. I am connected to cube and other cube functions work.
>> If i try changing function to
>>
>> =CUBESET("adv";"[Geography].[Geography].[All Geographies].[United
>> Kingdom].[England].children";"Top 10 Cities by Profit";0)
>>
>> I dont get error and i get data from Analisys Services. Seems like the
>> complexity of the statement gives trouble.
>>
>> Screenshoot 1 (working formula)
>>
>> http://h1.ripway.com/mivar/cubeset1.JPG
>>
>> Screenshoot 2 (not working formula)
>>
>> http://h1.ripway.com/mivar/cubeset2.JPG
>>
>>
>>
>>
>>
>>
>
>

...that the discpline doesnt exits


"michael vardinghus" <xx> skrev i en meddelelse
news:OKx0f5z6IHA.4292@TK2MSFTNGP02.phx.gbl...
> It was an excel questin and answer.
>
> Because you dont know how to get Excel to work with other platforms doesnt
> mean that discipline exists.
>
> Did u read my posts at all ?
>
> "Wigi" <Wigi@discussions.microsoft.com> skrev i en meddelelse
> news:C952DEA4-3DEA-4137-8D53-CCDBB4EAC34E@microsoft.com...
>> And this is an Excel question?
>>
>> --
>> Wigi
>> http://www.wimgielis.be = Excel/VBA, soccer and music
>>
>>
>> "michael vardinghus" wrote:
>>
>>> Solved !!!
>>>
>>> In the first was a typo-error - correcting that wasnt enouhg but it was
>>> because in excel i use ";" as separator but in sentence for AS i have to
>>> use
>>> ","
>>>
>>> So sentenced had to be corrected so in the part that goes to AS within
>>> "" i
>>> have to use "," as separator.
>>>
>>> http://h1.ripway.com/mivar/cubest3.JPG
>>>
>>>
>>>
>>> "michael vardinghus" <xx> skrev i en meddelelse
>>> news:e8zQo1Y6IHA.3816@TK2MSFTNGP03.phx.gbl...
>>> >I am using cubefunctions against Analysis Services and i follow
>>> >instructions in this:
>>> >
>>> > http://office.microsoft.com/download...AM102200231033
>>> >
>>> > When i type in function from page 6 step 8:
>>> >
>>> > =CUBESET("aw",CONCATENATE("DESCENDANTS([Geography].[Geography].[All
>>> > Geographies].[",$C$4,"], 2)"),"Top 10 Cities by
>>> > Profit",2,"[Measures].[Reseller Gross Profit]")
>>> >
>>> > I get a #N/A error. I am connected to cube and other cube functions
>>> > work.
>>> > If i try changing function to
>>> >
>>> > =CUBESET("adv";"[Geography].[Geography].[All Geographies].[United
>>> > Kingdom].[England].children";"Top 10 Cities by Profit";0)
>>> >
>>> > I dont get error and i get data from Analisys Services. Seems like the
>>> > complexity of the statement gives trouble.
>>> >
>>> > Screenshoot 1 (working formula)
>>> >
>>> > http://h1.ripway.com/mivar/cubeset1.JPG
>>> >
>>> > Screenshoot 2 (not working formula)
>>> >
>>> > http://h1.ripway.com/mivar/cubeset2.JPG
>>> >
>>> >
>>> >
>>> >
>>> >
>>> >
>>>
>>>
>>>
>
>