Cubeset function problem

  • Thread starter Thread starter michael vardinghus
  • Start date Start date
M

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
 
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
 
And this is an Excel question?

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


michael vardinghus said:
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 said:
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
Click to expand...
Click to expand...
 
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 said:
And this is an Excel question?

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


michael vardinghus said:
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 said:
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
Click to expand...
Click to expand...
Click to expand...
 
....or even bothered to look at screenshots..


michael vardinghus said:
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 said:
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
Click to expand...
Click to expand...
 
...that the discpline doesnt exits


michael vardinghus said:
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 said:
And this is an Excel question?

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


michael vardinghus said:
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
Click to expand...
Click to expand...
Click to expand...
 
Back
Top