Cubeset function problem

[michael vardinghus]

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

http://office.microsoft.com/download/afile.aspx?AssetID=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

 

[michael vardinghus]

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

 

[Wigi]

And this is an Excel question?

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

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

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

http://office.microsoft.com/download/afile.aspx?AssetID=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

 

[michael vardinghus]

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 ?

And this is an Excel question?

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

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

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

http://office.microsoft.com/download/afile.aspx?AssetID=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

 

[michael vardinghus]

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

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

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

http://office.microsoft.com/download/afile.aspx?AssetID=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

 

[michael vardinghus]

...that the discpline doesnt exits

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 ?

And this is an Excel question?

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

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
I am using cubefunctions against Analysis Services and i follow
instructions in this:

http://office.microsoft.com/download/afile.aspx?AssetID=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