Showing posts with label browse. Show all posts
Showing posts with label browse. Show all posts

Thursday, March 8, 2012

AS2005 error

I was trying to browse a cube and just started getting the following error:
Attempted to read or write protected memory. This is often an indication
that other memory is corrupt.
SP2 has been installed more than two weeks ago and everything was working
since then.
Any help is appreciated.
GIlgameshHi! Gilgamesh
Were you able to come over this issue? If so can you please let me know why
this issue came up? I am facing the same problem now.
--thanks and regards,
Prasad

AS2005 error

I was trying to browse a cube and just started getting the following error:
Attempted to read or write protected memory. This is often an indication
that other memory is corrupt.
SP2 has been installed more than two weeks ago and everything was working
since then.
Any help is appreciated.
GIlgamesh
Hi! Gilgamesh
Were you able to come over this issue? If so can you please let me know why
this issue came up? I am facing the same problem now.
--thanks and regards,
Prasad

Saturday, February 25, 2012

AS 2005 cube browsing with an unprocessed measure group

Hi,

Is it possible to browse a AS 2005 cube in the Cube browser without having processed one of the measure groups.

These measure groups only share a few dimensions and are independent of each other.

Is there a way to browse the cube without having to delete the unprocessed measure group in the AS project/Mgmt studio? There is no real option to disable a measure group though.

Regards

Yes. You should be able to clear one of the measure groups in your cube and still be able to browse the cube.You can send ProcessClear command for that.

Another idea is to create a Perspective and select into it on the measures and dimensions you interested to show to your users.

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

AS 2005 browse cube problem

I have successfully deployed an Analysis Services Project on Analysis
Server 2005 with SP1. However, when I try to browse the cube using
either BI studio or SQL Server management studio, everything stucks.
Dimensions browsing and cube processing works fine!
Any ideas?
Thanks, MakisYou can use Profiler to trace against Analysis Services with 2005. I suggest
you give that a try to examine what is happening behind the scenes
David Lundell
Principal Consultant and Trainer
www.MutuallyBeneficial.com
David@.MutuallyBeneficial.com
<gmarketos@.gmail.com> wrote in message
news:1147262990.507126.46230@.j33g2000cwa.googlegroups.com...
>I have successfully deployed an Analysis Services Project on Analysis
> Server 2005 with SP1. However, when I try to browse the cube using
> either BI studio or SQL Server management studio, everything stucks.
> Dimensions browsing and cube processing works fine!
> Any ideas?
> Thanks, Makis
>|||Thank you David for your answer.
After all I realized that my firewall created the problem.
Makis
David Lundell wrote:[vbcol=seagreen]
> You can use Profiler to trace against Analysis Services with 2005. I sugge
st
> you give that a try to examine what is happening behind the scenes
> --
> David Lundell
> Principal Consultant and Trainer
> www.MutuallyBeneficial.com
> David@.MutuallyBeneficial.com
> <gmarketos@.gmail.com> wrote in message
> news:1147262990.507126.46230@.j33g2000cwa.googlegroups.com...

AS 2000, Excel 2003 and calulated measures

Hi

I have created a calculated measure - which when i view in the Analysis Manager - Browse it displays what I need.

In my Excel Pivot Table I cannot see the field when I Show Field List? is it possible to have calc members in Excel 2003?

however, my initial problem is this (and I am hoping someone can come up with a better solution):

I have a fact table that is simply number of hours worked per month and linked to dimensions such as the customer. Each Customer has a budgeted time (which is on the customer dimension) - I need to include this budget.

I have a separate cube that is the detail of the budget and I have tried creating a virtual cube - the problem with this is the budget is only visible if I use dimensions from that cube and the hours are only visible when I use dimensions from that cube - I would liek to see them together. (the dimensions in both cubes are identical)

Anyone?

Steve

Sounds like you have a bunch of private dimensions in your cubes. Its been a while since I worked on 2K, but i think global dimensions (dimensions that can be shared in virtual cubes) are called "shared dimensions". If you used the wizard to create the dimensions and cubes I think it defaults to adding dimensions as private.

|||

That may solve the virtual cube issue - thanks.

Any idea why I cannot see a calculated member in Excel while I can see it in the MMC browser?

Thanks

|||

Shared dimensions and virtual cubes work a treat - thanks.

Apparently, a calculated measure that is based on a dimension table does not appear in Excel 2003!!