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 - jhpuddyhave 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|||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|||You can do one thing If you have created a Analysis services project ie cube.
you can create one using "create datasource from other object" from add data
source.
Amarnath
"jhpuddy" wrote:
> 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|||Yes, I know I have done that. It lets you create a data source but does not
recognize that data source when you try to create a data source view. It
puts you into a sort of loop.
--
New user - jhpuddy
"Amarnath" wrote:
> You can do one thing If you have created a Analysis services project ie cube.
> you can create one using "create datasource from other object" from add data
> source.
> Amarnath
> "jhpuddy" wrote:
> > 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