Refresh calculation when working on imported as db

Hi,
I created a new solution and imported an AS db to it so I can avoid to work on the database itself.
Now, when I change an MDX formula in a calculation, I cannot see the change effect in the browser without re-processing the cube.

What Am I missing? There sure is a way to see the effect of a calculation change by using some kind of refresh? I tried re-connect and refresh and save, nothing works.

Thanks,
Philippe

The BI project you imported is offline, changes to calculations are only saved to the local .cube file (while the cube browser gets the data from the live server). That's why you need to re-deploy (not necessarily with processing though) on the server. For editing calculations and quickly seeing the effects, it's easier to work in online mode (from Visual Studio, File -> Open -> Analysis Services Database).

Adrian Dumitrascu

|||

Adrian Dumitrascu wrote:

The BI project you imported is offline, changes to calculations are only saved to the local .cube file (while the cube browser gets the data from the live server). That's why you need to re-deploy (not necessarily with processing though) on the server. For editing calculations and quickly seeing the effects, it's easier to work in online mode (from Visual Studio, File -> Open -> Analysis Services Database).

Adrian Dumitrascu

Yes Offline you need to deploy before you see the changes, in online mode you need to SAVE to see the changes.

That requires some tricky organization when working as a team...

Also, tough not to break something working when changing a formula.
Lastly Sourcesafe becomes hard to use like that.
SourceSafe does a poor job anyways with cubes. When you delete an object like cube or dataview you cannot get it back from the history. It shows it in the project exlporer but says object has been deleted and is invalid...

I sure yet have to master VSS however I suspect that there is room for improvement in this working model.

Philippe

Reference Sub-Report Value on Main Report

I have values on 2 Sub- Reports that I need to do reference on the main
report to do a particular calculation.
I was wondering if there is anyway that I can reference the sub-report
values from the main-report without making a specific call to the database
just to obtain the one value that I need.
--
L Anthony JohnsonSometimes what you can do is reference first( )of the dataset. Doesn't
always work it depends on where you are doing it.
=first(Fields!fieldname.Value,"datasetname")
of course, if you want something besides the first value then this will not
work for you.
Bruce L-C
"L Anthony Johnson" <ppsyco2@.nospamm4m3bellsouth.net> wrote in message
news:%23uxZCGGZEHA.3480@.TK2MSFTNGP11.phx.gbl...
> I have values on 2 Sub- Reports that I need to do reference on the main
> report to do a particular calculation.
> I was wondering if there is anyway that I can reference the sub-report
> values from the main-report without making a specific call to the database
> just to obtain the one value that I need.
> --
> L Anthony Johnson
>|||The Sub-Reports have their own datasets.
How would I reference the sub-reports dataset in the main report?
Landry
--
L Anthony Johnson
Newbie
"Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
news:%23sDUjtGZEHA.3432@.TK2MSFTNGP10.phx.gbl...
> Sometimes what you can do is reference first( )of the dataset. Doesn't
> always work it depends on where you are doing it.
> =first(Fields!fieldname.Value,"datasetname")
> of course, if you want something besides the first value then this will
not
> work for you.
> Bruce L-C
> "L Anthony Johnson" <ppsyco2@.nospamm4m3bellsouth.net> wrote in message
> news:%23uxZCGGZEHA.3480@.TK2MSFTNGP11.phx.gbl...
> > I have values on 2 Sub- Reports that I need to do reference on the main
> > report to do a particular calculation.
> >
> > I was wondering if there is anyway that I can reference the sub-report
> > values from the main-report without making a specific call to the
database
> > just to obtain the one value that I need.
> >
> > --
> > L Anthony Johnson
> >
> >
>|||This is a good question, as I have the same problem. Does anyone know how
to access a data/value in a subreport?
"L Anthony Johnson" <ppsyco2@.nospamm4m3bellsouth.net> wrote in message
news:OD#gfZPZEHA.1980@.TK2MSFTNGP09.phx.gbl...
>
> The Sub-Reports have their own datasets.
> How would I reference the sub-reports dataset in the main report?
> Landry
> --
> L Anthony Johnson
> Newbie
> "Bruce Loehle-Conger" <bruce_lcNOSPAM@.hotmail.com> wrote in message
> news:%23sDUjtGZEHA.3432@.TK2MSFTNGP10.phx.gbl...
> > Sometimes what you can do is reference first( )of the dataset. Doesn't
> > always work it depends on where you are doing it.
> > =first(Fields!fieldname.Value,"datasetname")
> >
> > of course, if you want something besides the first value then this will
> not
> > work for you.
> >
> > Bruce L-C
> >
> > "L Anthony Johnson" <ppsyco2@.nospamm4m3bellsouth.net> wrote in message
> > news:%23uxZCGGZEHA.3480@.TK2MSFTNGP11.phx.gbl...
> > > I have values on 2 Sub- Reports that I need to do reference on the
main
> > > report to do a particular calculation.
> > >
> > > I was wondering if there is anyway that I can reference the sub-report
> > > values from the main-report without making a specific call to the
> database
> > > just to obtain the one value that I need.
> > >
> > > --
> > > L Anthony Johnson
> > >
> > >
> >
> >
>

Reference previously calculated values in table

I have a table with two columns.
Column A contains a complicated calculation. Column b contains a new calculation which requires the value from Column A. Is there a way to reference the Column A value without re-entering the formula.
Thanks for your help in advance.=ReportItems!textbox1.Value.
[Replace textbox1 with the appropriate cell name in the table.]
--
Ravi Mumulla (Microsoft)
SQL Server Reporting Services
This posting is provided "AS IS" with no warranties, and confers no rights.
"SAcanuck" <SAcanuck@.discussions.microsoft.com> wrote in message
news:1A68EE0F-1789-4F2E-973B-61790F19D657@.microsoft.com...
> I have a table with two columns.
> Column A contains a complicated calculation. Column b contains a new
calculation which requires the value from Column A. Is there a way to
reference the Column A value without re-entering the formula.
> Thanks for your help in advance.