This. Its right there... hope you haven't wasted too much time?....

Thank you, James.

This gives us the ability to be able to understand the translation the universe is applying as well as getting round the horrible way of pulling data into...

WHAT!!??

This is amazing news, you have a man hug and several thousand prokelly points if you can tell me if you can see the sql within the WEBII report...

The universe in our instances is a supplier provided translation layer of the relational database. Whenever one of those products is upgraded, the supplier also provides a modified / updated...

But can you connect to the boxi universe using the oleb db for oracle?

I am sure it is, but, do you know how? because that's what I was after! 🙂

smecharrafie (10/21/2011)

---

Issue resolved, turns out I needed to modify some SSAS properties such for analysis to utilize more server resources, these include:

OLAP \ Process \ AggregationMemoryLimitMin,

OLAP \ Process \ AggregationMemoryLimitMax

OLAP...

Isn't that exactly what I...

saprajun (8/23/2011)

---

Hi All,

I have a cube and set to scheduled MOLAP every 24hrs..Every partition shows cube is processed successfully for every 24hrs but I dont see the incremental data while...

Run using something like

SELECT [Measures].[POPULATION] ON ROWS,

Topcount([Hierachy].[Country States].[City],5,[Measures].[POPULATION]) on Columns,

FROM [YOURCUBE]

Perfect - thanks a lot. Thinking about this, I can set my ROLAP partition slice this way, but my "everything else" partition I guess needs slicing too.

Can you use something...

I use SELECT * INTO from VIEW a number of times to prep my datawarehouse each morning. I whap an index on the tables, and it dramatically improves the ROLAP...

I have that book, and it is interesting if you are into understand how it completes a mining query, and how to tweak it.

I would say that it's certainly aimed...

I have resolved this. When I say resolved, I mean i now understand why.

I had LazyAggregations enabled, on a lowspec virtual box which runs the entire Bi stack. While I...

Thanks for the supportive comments guys! it's appreciated.