Ranet-uilibrary Help

40 views
Skip to first unread message

Colin Banfield

unread,
Nov 29, 2009, 10:35:43 AM11/29/09
to ranet-uili...@googlegroups.com
Hi,
 
I installed the application on Windows 7 but don't know how to run it. SilverLight 3 and .NET 3.5 are installed. When I click the MdxFormatter Console executable, a command line window opens up briefly and disappears.
 
 
Thanks,
 
Colin 

Dan Slaby

unread,
Nov 30, 2009, 12:38:15 AM11/30/09
to ranet-uili...@googlegroups.com

I have the same problem. I down loaded the source code and tried to run it. The first thing I noticed is the default OLAP connection string is pointed to ./SQL2008 which is not the same as my machine. The second difference is the spelling of Adventure Works DW (mine does not have the spaces). I can get it to check the connection, but I get a return error that I don’t have permissions or else the database does not exist. Will post a response when I figure out making the connection. Dan

Galaktika OpenSource

unread,
Nov 30, 2009, 6:46:14 AM11/30/09
to Ranet.UILibrary.Olap
Hi, Colin

MDXFormatter.exe is console application which simply parse and format
all files "*.mdx" in current directory.

You can run it from console:
cmd.exe
cd %PathToSamples%
MDXFormatter.exe
or
MDXFormatter.exe MdxSample.mdx
or
MDXFormatter.exe > MyOutputFile (to redirect output)



As for OLAP controls:

You need to build the sample application before run it. You can use
Visual Studio development webserver or can deploy it to IIS. Set
"Startup project" to ..\Samples\UITest.Web\UITest.Web.csproj.

Please read: [http://code.google.com/p/ranet-uilibrary-olap/wiki/
Readme]


Regards,
Anatoly

Galaktika OpenSource

unread,
Nov 30, 2009, 7:21:02 AM11/30/09
to Ranet.UILibrary.Olap
Hi, Dan

You are right. You need to change connection OLAP Connection string to
any existing OLAP Database to which you have rights.

Sample connection strings:
[http://www.connectionstrings.com/olap-analysis-services]

You can test you connection string for example in MDXStudio:
[http://www.mosha.com/msolap/mdxstudio.htm]

Start MDXStudio, click "Connect" and paste your connection string to
"Other connection string properties" text box.
If you can connect in MDXStudio then you can connect in our sample
application.

Regards,
Anatoly


Galaktika OpenSource

unread,
Nov 30, 2009, 7:42:39 AM11/30/09
to Ranet.UILibrary.Olap
Hi, Colin

May be you have not processed your database?
Can you get any data from it by any other tool?

For example in Management Studio:
- Connect to Analysis Services
- select database, right click
- New Query - MDX
- write (or copy/paste from our sample application "Pivot Grid" tab)
and execute MDX query (F5)

Regards,
Anatoly

Reply all
Reply to author
Forward
0 new messages