Build Report Model from Analysis Service Database

MS SQL SERVER

    Next

  • 1. RunningValue in Drilldown problem
    HI, We are using RunningValue function to alternate color for displaying rows. Here is the property value for backgrond color: =iif(RunningValue(Fields!Row_Date.Value, CountDistinct,Nothing) Mod 2, "white", "#E4E7E6") We are having a problem with using that and a drill down at the same time. The first drill down works fine, but the second does not. Any thoughts? Michael
  • 2. Returning Customized Errors
    I have a report server (separate box) and a SQL Server (separate box). I have a report that uses a stored procedure to return a dataset. The stored procedure tests for parameter errors and returns an error message if any parameter is not correct. If I log into the report server it returns errors correctly and recognizes my username. I tried loading RS and SQL Server on the same box and running from an XP PC through Internet Explorer. This works correctly. Here's my problem: If I log into my XP PC as myself, run RS on a server box itself, and run MS SQL Server by itself on it's own server box, then... 1 - It does not recognize my username ... so I am using RS secured hard-coded username/password. 2 - It does not return my customized error. I don't know how to get around this. It has something to do with going to more than 1 other box (more than 1 hop??) A co-worker told me to get my System Administrator to configure my Report Server to "Enable Delegation". We configured the RS from the domain controller, and I rebooted the RS. This didn't solve my problem. Any help is appreciated. Thanks
  • 3. Dynamicly positioning any textbox/object
    Hi I do have a matrix and i need to place a textbox justat the end of this matrix. Is it possible? I tried to do something with Location property but didnt get through. Sorry to insist but its damn urgent Thanks in Advance
  • 4. .net 2002 and RS
    Hi is it possible to work on with in .net 2002 IDE with reporting services. If yes, than what extra i may need to install? Thanks in advance

Build Report Model from Analysis Service Database

Postby Q2hhaSBMaW5n » Thu, 14 Jul 2005 13:19:13 GMT

I try to build a report model that have data source point to AS Database, but 
i can't.
This is what i try: change the provider to OLE Db AS 9.0 and select the AS 
database, but the data source view can't detect a data source.
another way i try is using an existing AS project, but the project combo box 
is empty.
Pls let me know way to do this. Thank you.

RE: Build Report Model from Analysis Service Database

Postby Q2hhaSBMaW5n » Thu, 14 Jul 2005 13:37:02 GMT

Just to add-on: I am using Microsoft SQL Server 2005 CTP version





Similar Threads:

1.SSAS 2005: Report model based on Analysis Services - problem with dimension

Hello,

I published report model based on analysis services database. Everyting 
looks fine, except that if dimension is joined to measure group not at the 
lowest level, then this dimension does not work.
I have date dimension that for some measure groups is at day level and for 
others and month level. And I cannot build reports using date dimenion based 
on month level measure groups.
Anyone can help me here?

Thanks


2.Creating a Report Model from Analysis Services Cube then Editing

I have been told that you can create a Report Model from an Analysis Services 
Cube in the Model Designer even though the documentation says you can not.  
I can import the Analysis Project that contains the cube into BI Development 
Studio but I can not create a model from that project.
Does anyone know how to create then edit a model in the Model Designer(BI 
Development Studio not Management Studio or Report Manager) that is based on 
an AS Cube?

-- 
New user - jhpuddy

3.Creating a Report Model from Analysis Services Cube then Editi

Amarnath,

Thank you for responding.

But the problem is that I can't create a model from a cube in BI Development 
Studio.  I can create one in Management Studio but I can not edit the Model 
after it is created.  We were planning on doing all of the formatting, 
grouping and filtering in the model but we can not do that if we can not edit 
it.  The only thing that comes up for the model is the source code, can not 
edit the code.
-- 
New user - jhpuddy


"Amarnath" wrote:

> have you noticed ? both while creating report model and cube you can see 
> something called "Data Source View" nothing but building relationships 
> between tables. so same refer your dw database and create view and you can 
> use report model to create reports using cube and view.
> 
> Amarnath
> 
> 
> "jhpuddy" wrote:
> 
> > I have been told that you can create a Report Model from an Analysis Services 
> > Cube in the Model Designer even though the documentation says you can not.  
> > I can import the Analysis Project that contains the cube into BI Development 
> > Studio but I can not create a model from that project.
> > Does anyone know how to create then edit a model in the Model Designer(BI 
> > Development Studio not Management Studio or Report Manager) that is based on 
> > an AS Cube?
> > 
> > -- 
> > New user - jhpuddy

4.SSAS 2005: Report model based on Analysis Services - problem w

Hi vimas,

I had the same issue.  It seems that report model based on OLAP doesn't 
support conformed dimension concept. (Any measure groups depending on the 
intermediate level of a dimension cannot use the dimension).  Since the model 
doesn't expose OLAP hierarchy, that may explains this behavior.




"Vimas" wrote:

> Unfortunatelly I cannot give you copy of our structure - that would be 
> against company policy.
> I do not get any error message when I create report. Report builder 
> interface is sensitive to your selections. Example: if you have a 
> perspective that contains 3 measure groups and one dimension exists (is 
> joined) just in 1st and 2nd measure group, then if you drop any attribute 
> from this dimension on report builder matrix, you will not be able to select 
> anything that is related to 3rd measure group. All related measures from 3rd 
> measuregroup disapear.
> Same if I have perspective with Date dimension - as soon as I select date 
> dimension, all measure groups that are not at the lowest day level (month, 
> not day) will disapear from report builder.
> 
> I hope you can help me, as our company is pushing reporting services to 
> become major reporting tool for our clients and this issue is a big deal for 
> us.
> 
> Regards,
> 
> 
> 
> 
> "Wei Lu [MSFT]" < XXXX@XXXXX.COM > wrote in message 
> news: XXXX@XXXXX.COM ...
> > Hi Vimas,
> >
> > Thank you for using MSDN Managed Newsgroup Support.
> >
> > Have you got any error message when you want to create the report?
> >
> > I would like to get the project from you to troubleshot. You may zip the
> > folder and send to me directly. I understand the information may be
> > sensitive to you, my direct email address is  XXXX@XXXXX.COM  (
> > Please remove ONLINE when you send the email ), you may send the file to 
> > me
> > directly and I will keep it secure.
> >
> > Sincerely,
> >
> > Wei Lu
> > Microsoft Online Community Support
> >
> > ==================================================
> >
> > When responding to posts, please "Reply to Group" via your newsreader so
> > that others may learn and benefit from your issue.
> >
> > ==================================================
> > This posting is provided "AS IS" with no warranties, and confers no 
> > rights.
> > 
> 
> 
> 

5.SSAS 2005: Report model based on Analysis Services - problem with dimension

Hi Vimas,

Thank you for using MSDN Managed Newsgroup Support.

Have you got any error message when you want to create the report?

I would like to get the project from you to troubleshot. You may zip the 
folder and send to me directly. I understand the information may be 
sensitive to you, my direct email address is  XXXX@XXXXX.COM  ( 
Please remove ONLINE when you send the email ), you may send the file to me 
directly and I will keep it secure.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so 
that others may learn and benefit from your issue. 

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.

6. Analysis Services vs Report Models

7. Can't create report model on Analysis Database

8. Analysis Services service hangs cube build / timeout on proces



Return to MS SQL SERVER

 

Who is online

Users browsing this forum: No registered users and 28 guest