I'm fairly new to Proclarity and I'm using 6.3. I just have desktop professional and we still don't have proclarity analytical server installed yet. I would like to work around with KPI Designer, how am I able to install it. Does it come with extra components and needs to be installed from the installation CD?
...Also folks any good resources in learning proclariy?
thanks in advance!!
Rok
Does anyone have any experience with this product? The documentation is weak (read nonexistant) and I'm not sure how to export a report so I can see how it works.
Thanks.
Hello,
Is it possible to have Proclarity calculate the totals desired below? I know ProClarity is summing the totals but is it possible to calculate the desired result below?
PYFMTD
FMTD Chg
FMTD Chg %
163325
-2817
-1.72%
1048020
19921
1.90%
351134
25698
7.32%
731017
-36191
-4.95%
509297
13356
2.62%
226993
6771
2.98%
194018
30535
15.74%
3223804
57273
23.89%
Incorrect
1.78%
Correct
Thanks,
Tony Spaulding
tony.spaulding@hotmail.com
I have Installed Proclarity 6.1 Web Professional in my local System and i am trying to open a report on Analysis server where sql server 2012 in installed.
There i found reports are only opening in professional mode and when ever i am trying to open in Stendard Mode i am getting below mentioned error for every report.
ERROR:- "The selected page could not be opened because the cube could not be found. Please choose a different page."
After getting this Error, i have uninstalled ProClarity 6.1 web Professional from my system and installed ProClarity 6.3; but still i am facing the same issue (not able to open reports in a standard mode)
What is the solution for this and is this compatibility issue with ProClarity 6.1 and 6.3 with sql server 2012?
What can I do about this? There doesn't seem to be any workaround, I've upgraded everything, including the Msiexec to 3.2 (v2), but the same error always pops up.
I've done other installs of the same product without any problem whatsoever.
Can anyone help?
Regards,
Incognitus
Hello Friends,
I am using an action report(SSRS Report) in a Proclarity report in which the user generate action report on some particular filters. The problem is : In this report (SSRS report) I am using two row groups and three data fields and intially i am displaying the report in collapsed manner. The report is working fine in BIDS and as well as on the report server. But when i am generating the report through prolarity , the report is getting generate but when i tried to expand the collapsed field its throwing an error
"An internal error occured on the report server. See the error log for more details. Specified argument was out of the range of valid values"
Can anyone help me out to solve this issue.
Thanks & Regard's
Hello everybody!
I've already posted this question before but this error never been resolved.
My DTS designer is totally screwed.
When trying to create new local package getting error message "Could not create Component Categories Manager".
I can't even use DTS to copy data in using DTS wizard.
Somebody recommended to reinstall SQL Server which I did but it didn't solve my problem.
Any other suggestions?
Thanks for your help
Lena
Does any one know of a way that a group of my developers can use this without giving them access to the rest of Enterprise manager?
Want to give them access to write queries and they are all Access developers so that I have to do as little training as possible then letting them have Query designer would keep them in their nice little world without hassing me to much.
Cheers for any help.
When using Enterprise Mgr on a workstation connected to a MSSQL Server, if I attempt to start a new DTS Package, I get the following msg:
Title: DTS Designer Error
Text : Could not create Component Categories Manager
I get the same msg when trying to edit an existing package. I tried to re-register Dtspkg.dll,Dtsui.dll, and dtsffile.dll. All were successful but Dtspkg.dll, which failed. Does anyone know what causes this, and what else I can try?
When i'm trying to open the table say return all rows in Enterprize manger it gives me an error saying
Query Designer encountered a query error
Unspecified Error.
I could not figure out what's goin on...
I appriciate if any one can help me out solving with this problem.
or what need to be done ?
Thanks a lot in advance!!!
Hari.
When I open my DTS package at my PC ( Client ) .There is an error message show like below .
DTR Designer Error.
There was a problem retriving the list of OLE DB providers.
No. Provider is selected .TO continue,you must select a valid provider.
Please help
Have anyone tried installing the DTS Designer 2000 Components in 64 Bit Environment
Vic
In SQL 2000 the query designer could be opened and the query type changed to create an INSERT.
Is this feature still available in SQL 2005?
If so, how do I open the query designer and change query types?
Thanks
Does anyone know if Microsoft provides a download of DTS Designer that I can use with SQL Server 2005 Express?
View 4 Replies View RelatedCan you turn on a grid in the designer to assist you with aligning tasks, etc. I've trie all kinds of things, but can't get a grid. Or even maybe rules? I'm probably missing something real simple, but can't find.
View 7 Replies View RelatedI use the Report Wizard to generate reports. Within the "Design the Query" screen, I try the query statement as :
exec mydb.dbo.rptSales @fortheyear
It shows me an error: Implicit conversion from data type sql_variant to smallint is not allowed. Use the CONVERT function to run this query.
The stored procedure of rptSales is
CREATE PROCEDURE dbo.rptSales
@pyear smallint=null
AS
.......
The rptSales has been tested OK on SQL Server Management Studio.
Actually, I have other similiar stored procedures using smallint as a parameter, and I can use the Report Wizard to generate reports, except the above one.
How can I fix this?
Thanks a lot,
Joe.
I have dragged 3 SqlDataSource Controls to the WebDesigner and none are appearing graphically in the Designer View, but they are in the Source View. How can I get the control to appear in the designer.
Thanks,
Mark
Hello!
Yesterday my DTS designer was fine and today suddenly when I open the package in designer there is nothing there.
I tried to create new package and it gave me an error when I was trying to save it "It is insufficient disk space to complete operation".
What does this mean?
Thanks
Lena
I am testing SQL Server 2000 and after having installed it on a machine with SQL 7 already on it everything went OK.
However, if I try to create a DTS package (or open and existing one) on either of my SQL Server instances I get a "DTS Designer Error". After which, the DTS package window opens but I can't see any of the tasks in the tool bar. I can't select any tasks from the Task option in the menu bar either.
Has anyone experienced anything similar? Any suggestions would be appreciated.
Thanks.
Barb
I am testing SQL Server 2000 and after having installed it on a machine with SQL 7 already on it everything went OK.
However, if I try to create a DTS package (or open and existing one) on either of my SQL Server instances I get a "DTS Designer Error". After which, the DTS package window opens but I can't see any of the tasks in the tool bar. I can't select any tasks from the Task option in the menu bar either.
Has anyone experienced anything similar? Any suggestions would be appreciated.
Regards,
Karl
Hello all
I've got SQL Server 7.0 SP1 installed (in a NT4 SP6 environment).
Recently, it came up with error whenever I try to open a table or a view (return all rows) inside the Enterprise Manager. The descriptive (NOT!) error message is like this:
"The query cannot be executed because some files are either missing or not registered", and on pressing "help",
the help files report
"Query Designer cannot locate your query files and cannot run your query"
I have tried re-booting the machine and upgrading mmc.exe to version 1.2 (from 1.1), but both in vain.
Can anyone shed some lights please?
Simon
Checked out BOL on this issue, but not enough info received to troubleshoot. Hoping someone out there has some input.
This issue is only happening on the server side not the client. Also, it suddenly appeared on three different machines.
Query Designer:
"An unexpected error happened during this operation" [Query} - Query Designer encountered a Query error: Unspecified error.
The how: In a database, go to tables and select a table known to have data right click on mouse and select Open Table, return all rows. This is when the error appears.
BOL states the the file may be corrupt or from a non-supported version of SQL Server EM. Nothing was installed on these servers and we're still on SP2. This error just all of a sudden appeared and spread to 3 different machines...
Another issue is the Return to Top function is disabled. This function provides the maximum number of rows to fetch.
Any assistance would be appreciated! Thanks.
When I try to Return All Records in a table, I receive the error "Query Designer encountered a query error: unspecified error." I can successfully view the design of the table just not the records themselves. This is happening in all of my tables in all dbases.
Thanks for any suggestions.
Thanks in advance for any help you may offer.
I have never seen this error before... When I click on DTS to either open an existing package or create a new one I get the following errors: Error in the DLL, DTS Design Error. When I try to create a new DTS it gives me the errors but still opens but I'm missing all of the connection objects except for MS data link and other connection. I had no problems designing and executing the packages from a development box. I'm not even refering to the typical scheduling problems that exist when SQL Agent is configured incorrectly!
Hi. I am not sure why, but i can't change any of the values in my Table Designer. I want to change my primary key's "IsIdentity" value to "yes" and the Identity Increment to "1" but everything is greyed out and nothing is editable. Please help! I am not in debug/run mode when i am editing these values. I have a feeling that I am going to feel stupid when somebody points out what i am (not) doing. So, any takers?
View 7 Replies View RelatedProblem Description: The following error is popping up and not allowing opening or running any of the DTS packages. Connection objects are not available in DTS Designer.
"Error in the DLL"
"Need to run the object to perform this operation"
We have reinstalled the MS SQL Server 2000 Standard Edition with Service pack 3 and MSO3031 hot fix. Still the issue continues.
Operating System:Windows 2000
Hi
According to the RDL spec (nov 2005), RDL Designers are supposed to preserved custom elements. In my initial test Visual Studio 2005 overwrites/removes any custom elements. I tried to find some support/samples of this but was unsuccessful.
Here is what I added
<Report xmlns="http://schemas.microsoft.com/sqlserver/reporting/2005/01/reportdefinition" xmlns:rd="http://schemas.microsoft.com/SQLServer/reporting/reportdesigner" xmlns:myNameSpace="http://myNameSpace.com/myNameSpace">
<CustomProperties name="Custom">
<myNameSpace:test>test</myNameSpace:test>
</CustomProperties>
..
Anybody have some advice about this.
Thanks Tobias
Whenever we open a task and choose the lookups tab ellypsis button we get this error
Microsoft SQL Server Management Studio has encountered a problem and needs to close. We are sorry for the inconvenience.
If you were in the middle of something, the information you were working on might be lost.
Any idea what might be causing this? Am I missing something?
Is it necessary to install SSRS and SSAS to see the designers in Visual Studio 2005? That would mean installing some parts of a SQL Server 2005 installation on my Vista SP1 machine, or just the BIDS.But i've tried the latter to no avail (it hangs), and the former doesn't make sense because i think the SQL engine would be needed, and doesn't that require a server OS? I'd just like to see the report and cube designers in VS2005. How do i do that? Does it have anything to do with running SQLServer setup? TIA!!
Hi,
I have sql server 2005 express and toolkits installed. However, I only see Report Server projects in my Visual Studio 2005 when I choose a Business Intelligence project.
Will someone please help me download the right file to start using SSIS designer?
Thanks,
Jae
Are there any training seminars/classes anyone would recommend attending? I am looking to further develop my Visual Studio Report Designer Skills. Leaning more to the intermediate/advanced side.
Hello,
I am developing some reports for an ASP.NET solution, but my IDE does not display the design view of the reports. Instead, it only displays the XML definition even when I click View Designer. Yesterday the reports showed up correctly, and I know that the design view is there. Is there a setting that has been changed somewhere?
Hi,
My database has just recentrly been upgraded to SQL 2005 and i have noticed a change in the interface when writing a query in "Query Designer"
For one of our tables we have a 'Time' field. I know that time only doesnt exist yet and upon insertion a default date of 30/12/1899 is automatically inserted. Im happy with that!
My concern is with Query Designer. If i build a query using the criteria grid and for the time field i filer on >=13:00:00 (example), the SQL that it creates looks like this:
(TIME >= CONVERT(DATETIME, '2007-10-17 13:00:00', 102))
As you can see is automatically inserts the current date instead of 30/12/1899. This obviously causes my sql to not work unless i manually change the date in the SQL to 1899-12-30
In SQL 2000 i did not have to do this, it would automatically write the SQL as :
(TIME >= CONVERT(DATETIME, '1899-12-30 13:00:00', 102))
Even if i enter 30/12/1899 13:00:00 into the criteria grid it still converts to current date.
Is there a setting somewhere for the Query Designer so that it defaults to 30/12/1899??
Regards,
Eddie S