Wednesday, March 7, 2012
Cube processed time always shows current time.
manager. Every time I open Analysis Services and click on my database, one
of my cubes shows the current time for being "processed" under metadata.
Not all of my cubes shows this time. My database and cube have the same
name (don't know if this means anything, but my other cubes have different
names.
Any help?
Eric
Message posted via http://www.webservertalk.comYou might get better help over in microsoft.public.sqlserver.olap or
microsoft.public.sqlserver.datawarehouse
Please post DDL, sample data and desired results.
See http://www.aspfaq.com/5006 for info.
"Eric Wiltrout via webservertalk.com" <forum@.webservertalk.com> wrote in message
news:55c55310d5784032b6089b6f75c89123@.SQ
webservertalk.com...
> I have an issue with the "processed" time that shows on the analysis
> manager. Every time I open Analysis Services and click on my database,
one
> of my cubes shows the current time for being "processed" under metadata.
> Not all of my cubes shows this time. My database and cube have the same
> name (don't know if this means anything, but my other cubes have different
> names.
> Any help?
> Eric
> --
> Message posted via http://www.webservertalk.com
Friday, February 24, 2012
Cube Calculation TAB Error
Could anyone please reply is it configuration problem or reinstalled VS2005 which is higly unlikely for me at the moment.
Many Thanks
Nasir
Check out http://support.microsoft.com/default.aspx/kb/926421.
Cube Browser
I created a cube in analysis services project in a computer where sql server 2005 is not installed there, when I try to click on Browser tab in the cube, the following error occurs:
TITLE: Microsoft Visual Studio
A connection cannot be made. Ensure that the server is running.
ADDITIONAL INFORMATION:
Unable to read data from the transport connection: An existing connection was forcibly closed by the remote host. (System)
An existing connection was forcibly closed by the remote host (System)
Anyone have any idea on how to solve it? Thanks in advance.
Daren
Did you deploy your cube? Did you process it?
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights
I tried to deploy it to my server using the ip address, the same connection error came up.
Daren
|||
This could be permission issue.
Check if you have Admin rights to Analysis Server.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights
Thanks for helping out. But where do I check the rights to Analysis Server? I tried browsing through the properties of the user, could not find anything about Analysis Server.
Daren
|||
Daren.
First, please make sure you install Analysis Services on your machine.
After you installed it, you should be able to deploy your project to Analysis Server.
I strongly recommend you try and work you way through tutorial for Analysis Services. Looks like you are missing very basic knowledge.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights
To make the picture clear, I already have analysis services installed and go through the tutorial provided in BOL, and I managed to get it to work fine in another computer (which I installed sql server with analysis services in it as well for testing purpose). Then I redo the same steps on the another computer (installed with the same settings), the only difference on both computer are testing pc is windows 2000 with latest sp installed, the other one (that I have problem browsing the data) is using windows server 2003. I have no idea how to go about from there, that's why I posted my question here.
Daren
|||
Are you an Admin on Win2003 machine?
Can you connect to Analysis Services using SQL Management Studio? Can you see your database ?
The project you develop in BI Dev Studio needs to be deployed. Only after you deploy the project to Analysis Server, you will be able to browse your cube.
After you deployed your cube, you can navigate to it in SQL Management studio and browse it from there.
Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.
Tuesday, February 14, 2012
CrystalReportViewer and ASP.Net
I am Asad, software developer. I am working in ASP.Net2005 with VB.Net 2005 and using CR.Net 2005. I having some problems.
Whenever i click some button on crystalreportviewer's toolbar, the page bocomes empty. Report becomes invisible.
I got ur address from Code Project while searching abt reports problem.
Plz help Me.
Regards
Asad NaeemDid you find an answer to your problem? I believe I have the same problem - I put together a CRViewer project using VB.net (2003). When reports are displayed with crosstabs, there is nothing there. I also get an error when the report has drill down group level code (for header display)i.e, "DrillDownGroupLevel=0" the remaining text does not appear to be part of the formula. All of these reports work fine using Crystal (10) on our server, which is where they are created. The reports are saved with data, so it's not a databse issue at all. Drill down is OKed in the properties of the viewer, so that's not an issue..
Is this some sort of versioning problem? Any tips on finding the source of the problem would be appreciated.|||Hi...
Yes i found the solution. Infact the buttons of the toolbar are server side controls. I have applied the condition in the Page_Load i.e,
if Not PostBack() then .... End If.
The scenerio was:::
I have used the typed report (report bidded with typed dataset)
When i click the button the page starts rendering and and dataset and everything becoes empty and due to the condition the dataset did not fill again that is why reports becmes invisible. I found the solution which
i have used cache for this purpose. At the time of loading the page, i saved the dataset in the cache with the time duration of 10 mins. Whenever i click any toolbar button the data is retrieved from the cached every time before 10 mins paases. After 10 mins page again retrieves the data from the database otherwise it retrieves the data from the cache. In this way dataset is never empty.
Contacts
00923334471758
usan807@.hotmail.com
asad.naeem@.gmail.com
anuab_lg@.yahoo.co.uk
Regards
Asad Naeem|||Sounds like yours was a bit different than mine - one thing I have found - If I recreate the report using the Crystal designer in VB.Net (2003), than the crosstab(s) shows. If I open the original report in the (VB) designer, it looks OK (you see the crosstabs, headings etc. in the designer), but even if I do a save as, there is no data when the report is viewed, so it looks like it's at least somewhat related to the fact that the original crosstab reports were created in CR10. I don't know enough about this yet, but I wouldn't think that should be the case. Am I wrong on that?
I've seen other people have had similar problems, but most of the questions have gone unanswered. Others have indicated that things go blank when they do something that requires the screen to be redrawn - could the problem have anything to do with Windows.Drawing routines that might be treated differently from one version to another?