A*******n
发帖数: 625 | 1 我建立了一个cube用SSAS 2008,我想建立一个页面，当我选这个Cube的时候，就会出现
它的Dimensions and Measures, 然后把自己想要的值放到报表里面。（所有的东西都
显示在网页上）。有没有哪位大腿告诉我一般要怎么做？或者说这整个过程是如何工作
的？
谢谢 各位大师 |
p********l
发帖数: 279 | 2 Join the webinar hosted by CINAOUG on September 15, 2011. You might get the
answers. |
B*****g
发帖数: 34098 | 3 ask presenter, hehe
the
【在 p********l 的大作中提到】
: Join the webinar hosted by CINAOUG on September 15, 2011. You might get the
: answers.
|
A*******n
发帖数: 625 | 4 Sep 15? I will be in china for visa.
都没有人做SSAS的吗？？？？？？？？ |
i*****w
发帖数: 75 | 5 You need to use ADOMD to connect to your Analysis Services and pull the
dimensions and measure groups. You need to learn MDX so as to render report
on the Web. You may want to try some commercial tools to query the OLAP cube.
Alternatively, you can try to host a reportings services report on your web
page and add the Dimensions as report parameters, in that way, the users
could render interactive reports.
【在 A*******n 的大作中提到】
: 我建立了一个cube用SSAS 2008,我想建立一个页面，当我选这个Cube的时候，就会出现
: 它的Dimensions and Measures, 然后把自己想要的值放到报表里面。（所有的东西都
: 显示在网页上）。有没有哪位大腿告诉我一般要怎么做？或者说这整个过程是如何工作
: 的？
: 谢谢 各位大师
|
A*******n
发帖数: 625 | 6 you are right. I spend couple dates to figure out how connect to Analysis
Services and pull the dimensions and measure groups. The First step is done.
now I will focus on MDX.
idtkonw, would you please tell me your contact information? email or QQ. I
think you should be good on SSAS. you will give me a big help.
my qq is 39193622
Thanks again. |
A*******n
发帖数: 625 | 7 one question:
foreach (CubeDimension cb in cube.Dimensions)
{
if (cb.Dimension.Name == this.dimensionList.SelectedValue)
{
foreach (CubeAttribute at in cb.Attributes)
{
if (at.Attribute.Name == "Year")
{
///////
}
how can I get the value of the "Year"?
I can not find at.Attribute.Value, something like that.
who know it? |
S*****0
发帖数: 538 | 8 You will need a MDX query for the data retrival, even though it is from
dimension.
Also, try AMO (Analytic Management Object) to see if it has anything so you
don't need to write MDX.
【在 A*******n 的大作中提到】
: one question:
: foreach (CubeDimension cb in cube.Dimensions)
: {
: if (cb.Dimension.Name == this.dimensionList.SelectedValue)
: {
: foreach (CubeAttribute at in cb.Attributes)
: {
: if (at.Attribute.Name == "Year")
: {
: ///////
|
i*****w
发帖数: 75 | |
A*******n
发帖数: 625 | 10 有没有可能建立一个stored procedure在analysis server上，当我在网页上选不同的
dimensions的时候，传不同的值到stored procedure. 比如我有(year and clientname
),当我选year的时候，传year进去，得到year(like 2007,2008).选clientname的时候
得到client name, like "Tom","jerry". |
|
|
s**********0
发帖数: 266 | 11 高版本的MS Excel可以直接连到SSAS的cube （‘Data’ tab -> From Other Sources
) 然后它有一个自带的designer让用户drag&drop所有的 Dimension fields 和
Measures到报告里。
SSRS也可以做，不过你事先要把所有的fields和layout设置好，不能让User选(你怎么
设计他们就看到什么） |
A*******n
发帖数: 625 | 12 这个我知道，问题是我要做的是客户可以选的。有一个小问题：MDX query 返回是什么
？是table还是其他什么的?
我的一个query:
select {} on 0, [Invoice].[Year].members on 1 from MasterC
返回是：ALL, 2007,2009,Unknow. 可是捆绑到DataTable上，却是空的。why?
AdomdConnection objConnection = new AdomdConnection(constr);
AdomdCommand objCommand = new AdomdCommand();
DataTable ds = new DataTable();
string strCommand = "";
objConnection.Open();
objCommand.Connection = objConnection;
strCommand="select {} on 0, [Invoice].[Year].members on 1 from MasterC";
objCommand.CommandText = strCommand;
AdomdDataAdapter objdataAdapter = new AdomdDataAdapter(objCommand);
objdataAdapter.Fill(ds);
ds is empty, why? |
A*******n
发帖数: 625 | 13 这个问题我解决了，谢谢各位老大。像这样用户自己可以选的，是不是不能用
REPORTING SERVER REPORT.只能用MDX,把结果把捆绑在Table or datagrid, dataview
上面？ |
A*******n
发帖数: 625 | 14 how to get distinct value of the quarter?
Invoice dimension include year, quarter, month and day, how to do it?
select {} on 0,
distinct{ [Invoice].[Quarter].members} on axis(1)
from [MasterC]
the result likes 1,2,2. it still duplicates.
need help
Thanks |
g***l
发帖数: 18555 | 15 你怎么用MDX QUERY些基本的SQL的东西呢 |
A*******n
发帖数: 625 | 16 The reason is all data in cube. I try to get dimension or hierarchy members
data. whatever, it seems working right now.
I think I have to use MDX, right?
Thanks |
i*****w
发帖数: 75 | 17 If you want to handle the binding of controls on the web UI from the cube,
yes, you have to use MDX. But how do you handle the drag and drop functions
like in Excel? Without a 3rd party software, it can be very complicated.
If you know the dimensions that the user will use, and you just want the
user to pick the members, then Reporting service will work, and you don't
have to worry about the MDX. Yet the report will be fixed format.
HTH
members
【在 A*******n 的大作中提到】
: The reason is all data in cube. I try to get dimension or hierarchy members
: data. whatever, it seems working right now.
: I think I have to use MDX, right?
: Thanks
|
A*******n
发帖数: 625 | 18 you are right, the problem is user can use any dimensions, can I still use
reporting service?
by the way, hierarchy in dimension is for SSAS 2000 or new for 2005 and 2008?
Thanks |
