ReportPortal
ReportPortal
Home | Profile | Register | Active Topics | Members | Search | FAQ
 All Forums
 ReportPortal General Forum
 Report Portal General Issues
 Problems creating OLAP...is there a ds threshold

Note: You must be registered in order to post a reply.
To register, click here. Registration is FREE!

Screensize:
UserName:
Password:
Anti-Spam Code:
Message:

* HTML is ON
* Forum Code is OFF
Smilies
Smile [:)] Big Smile [:D] Cool [8D] Blush [:I]
Tongue [:P] Evil [):] Wink [;)] Clown [:o)]
Black Eye [B)] Eight Ball [8] Frown [:(] Shy [8)]
Shocked [:0] Angry [:(!] Dead [xx(] Sleepy [|)]
Kisses [:X] Approve [^] Disapprove [V] Question [?]

 
Check here to subscribe to this topic.
   

T O P I C    R E V I E W
njojo Posted - 01/30/2007 : 06:42:59
Whenever I choose to create an OLAP report, Choose the server/database...then it takes a very long time to give me cube options. We have very large dimensions...is this related to the size? Does report portal have a threshold at which you begin to have problems?

I am also having the problem with filters. Sometimes the dimension used as a filter shows up as empty and other times I get this error:
Error occurred during attempt to iterate schema.

Can anyone shed some light on what is going on and how I can fix it?

Thanks,
njojo
9   L A T E S T    R E P L I E S    (Newest First)
admin Posted - 02/12/2007 : 03:39:31
You might be having a memory problem with XMLA and IIS.

Try modifying the datasources.xml file located here:

C:\Program Files\Microsoft XML For Analysis SDK\Config\datasources.xml

Please open it in Notepad.

You need to modify the connection sting inside DataSourceInfo XML tag.

<DataSourceInfo>Provider=MSOLAP.2;Data Source=local; Client Cache Size=150; Execution Location=3; Default Isolation Mode=1; Large Level Threshold=100;</DataSourceInfo>

Here are the connection properties you should try to change:

1) Client Cache Size=150; - try to make smaller
http://msdn2.microsoft.com/en-us/library/aa237360(SQL.80).aspx

2) Execution Location=3; 3 - Queries are executed on the server.
http://msdn2.microsoft.com/en-us/library/aa237489(SQL.80).aspx

3) Default Isolation Mode=1;
http://msdn2.microsoft.com/en-us/library/aa237474(SQL.80).aspx

4) Large Level Threshold=100; - try to make smaller
[url]http://msdn2.microsoft.com/en-us/library/aa237403(SQL.80).aspx[/url]
marco Posted - 01/30/2007 : 23:13:15
Analysis Services 2000 is that Standard or Enterprise Edition ?

If Standard only 2Gb RAM is supported and I have seen more GBs makes it slower but this is not always `the case !

Marco
njojo Posted - 01/30/2007 : 18:10:53
Analysis Services is on the web server (along with Report Portal). That is the server that has the 8 GB of ram.

Sql Server 2000 SP4, Standard Edition is on a different server.

The reports are not available for viewing outside of my company.
marco Posted - 01/30/2007 : 14:52:00
Hi,

8GB RAM is that for SQL Server or Analysis Services 2000 ?

I was expecting that the webserver and SQL Server were on 1 server and OLAP on the other ?

Do you use SQL Server 2000 sp3 or sp4 and use Enterprise Edition ?

Can I see somewhere on internet the reports ?

Regards, Marco
njojo Posted - 01/30/2007 : 13:09:57
Also, with ReportPortal 2.0, Build 34 what version of the .net framework should we be running?
njojo Posted - 01/30/2007 : 12:21:57
We do plan to move to the latest version...but I need help now. Has anyone seen this error and can tell me what to do........

We just added ram to the web server, now has 8GB....AS2000 is running on the web server. SQL Server 2000 is on another machine.

Still getting: error occurred during attempt to iterate schema

Any help is greatly appreciated as we are to release this to a customer in 5 days.

marco Posted - 01/30/2007 : 10:41:30
Maybe you can test with the latest build: ReportPortal 2.1 Build 135 it should be faster than 2.0.

MArco
njojo Posted - 01/30/2007 : 06:57:26
OLAP SSAS2000
Windows 2003
ReportPortal 2.0, Build 34

I have not tried it with Adventure Workds DW.

When I try to access the cubes (through olap creation) the service w3wp.exe hogs the memory on the machine.
marco Posted - 01/30/2007 : 06:47:34
Hi,

Which OLAP: SSAS2000 or SSAS2005 ?

If SSAS2005 SP1 or higher ?

Windows 2000 or 2003 Server ?

Which ReportPortal build ?

Do you have the same problems with Adventure Works DW ?

Regards, Marco

ReportPortal © 2000-2002 Snitz Communications Go To Top Of Page