I do not have the option to create an Integration Service project in Business Management Studio

Hi,

I have installed the advanced toolkit for Microsoft Sql server 2005, with the SQL server Business Intelligence Development Studio but I don't have the option the create a Integration Service project. I only have the Report Server project option available.

Do I have to download something else to get it?

I do not have a SQL server instance installed on the machine I installed the toolkit on.

Thank you

What version of SQL Server do you have installed? You need Standard, Developer, or Enterprise.|||

Oh I see, I have the express edition.

I guess I'll get to play with that if we buy one of those editions some day

Thank you

|||Developer edition is $50, but cannot be used in a production environment.

I can't debug my SQL Server project

I'm coding a TVF in C# and the debugger doesn't stop at all. It used to work when I was coding scalar functions, but it stop working since I removed my assembly from the DB and register it manually to test my SQL scripts. I removed the assembly again from my DB and re-deployed it with VS.2005 hoping that will fix it, but it didn't work. Right now I can't debug.

Have anybody had a problem like this before? Any help will be appreciated.

Do you use your TVF in default test script in your VS project?|||Yes. The weird thing is that the debugger was working before, and I debugged scalar functions. But since I deployed the assembly manually and then removed it to deployed it from VS.2005, somehow the debugger stopped working.|||Check content of output window, you could find error messages here.|||

Got it. There was a problem with a commented section in query.

Thank you.

sql

i cant create a model

I try to create relational database but i cant develop a model. after i create a database i will create an OLAP cube for my project.i dont want to complex model but i cant create a simple database. it may be marketing, CRM or another. i dont know what fields and tables i should create. i saw sample databases such as northwind and foodmart but i must create original database for my project. please help meeeeeeWhat has the teacher covered so far? Do you have the original assignment (a URL or scanned copy would help us a lot)?

By the way, beware of asking other folks to actually do your homework for you... Asking for help is fine, but it is risky to let them actually do the assignment for you! :rolleyes:

-PatP

I can't debug my SQL Server project

I'm coding a TVF in C# and the debugger doesn't stop at all. It used to work when I was coding scalar functions, but it stop working since I removed my assembly from the DB and register it manually to test my SQL scripts. I removed the assembly again from my DB and re-deployed it with VS.2005 hoping that will fix it, but it didn't work. Right now I can't debug.

Have anybody had a problem like this before? Any help will be appreciated.

Do you use your TVF indefault test script in your VS project?
|||Yes. The weird thing is that the debugger was working before, and I debugged scalar functions. But since I deployed the assembly manually and then removed it to deployed it from VS.2005, somehow the debugger stopped working.|||Check content of output window, you could find error messages here.|||

Got it. There was a problem with a commented section in query.

Thank you.

I am practicing by building a PM Online App

In my Project table.

I have a column called projSeqNum (Project Sequence Number) I was with a fellow techie -data modeler- and I think it was just placed with an int data type. I think a 4 length.

My question is what would be the correct data type here. There could be 100's of thousands of unique Project ID's so I need something sturdy but not overboard.

Any ideas?

Should I use a varchar data type?|||

Hi

The int datatype should be fine - it allows for numbers up to 2,147,483,647.

If that's not big enough, you could use bigint, which goes up to 9,223,372,036,854,775,807.

HTH

I a view in Access Project I see only "all columns"

I try to create a view in Access Project but in design view I only see "all columns" in a table. The individual columns are not listed. This happens only with a certain SQL Server database. Any suggestions ?See: http://support.microsoft.com/kb/255041

Hyperlinks is SSRS 2005

Hi All,
Please help me in using the hyperlinks in the SSRS to call a page within a
particular frame.
I have been working on a project where i a using HTML frames and SSRS is a
part of the right frame.i have to make sure that the URL
link(eg:-http://www.google.com) opens up in the right frame,and not in a
separate window.
This is how i tried doing it.
1.In a report i have put a image control.
2.I go to the properties of the image, and go to "Navigation" tab and select
"Jump to URL" combo box and edit the expression.
3.The expression that i have given is:
="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
where fraRightFrame is the frame,in which want to open the URL.
After i deploy this report and try clicking on the link, a page loads with
the message "Page cannot be displayed" and in the address bar, i can see the
above javascript.
Please help me as to how i can call a URl in the same frame where the
report is running.
Note:-
I am using SQL server reporting services 2005 with SP1 along with Shreapoint
server 2003.
Waiting for your responce,
Thanks in advance,
Regards,
Archana KamathPlease also note that Javascript works fine in the report.That is when i try
opening the report using the report manager /reportserver it works fine.When
i click the link, the page ('google') gets loaded.
But when i include the same report in my sharepoint site ,using the page
viewer webpart and try accessing the link,it throws up an error saying "Page
cannot be displayed" and the javascript gets pasted on the address bar.
Any idea why this behaviour?
Many thanks inadvance,
Regards,
Archana
"Archana" wrote:
> Hi All,
> Please help me in using the hyperlinks in the SSRS to call a page within a
> particular frame.
> I have been working on a project where i a using HTML frames and SSRS is a
> part of the right frame.i have to make sure that the URL
> link(eg:-http://www.google.com) opens up in the right frame,and not in a
> separate window.
> This is how i tried doing it.
> 1.In a report i have put a image control.
> 2.I go to the properties of the image, and go to "Navigation" tab and select
> "Jump to URL" combo box and edit the expression.
> 3.The expression that i have given is:-
> ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> where fraRightFrame is the frame,in which want to open the URL.
> After i deploy this report and try clicking on the link, a page loads with
> the message "Page cannot be displayed" and in the address bar, i can see the
> above javascript.
> Please help me as to how i can call a URl in the same frame where the
> report is running.
> Note:-
> I am using SQL server reporting services 2005 with SP1 along with Shreapoint
> server 2003.
> Waiting for your responce,
> Thanks in advance,
> Regards,
> Archana Kamath
>|||Hi All,
The script
="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
worked fine.
Many Thanks
Archana
"Archana" wrote:
> Please also note that Javascript works fine in the report.That is when i try
> opening the report using the report manager /reportserver it works fine.When
> i click the link, the page ('google') gets loaded.
> But when i include the same report in my sharepoint site ,using the page
> viewer webpart and try accessing the link,it throws up an error saying "Page
> cannot be displayed" and the javascript gets pasted on the address bar.
> Any idea why this behaviour?
> Many thanks inadvance,
> Regards,
> Archana
> "Archana" wrote:
> > Hi All,
> >
> > Please help me in using the hyperlinks in the SSRS to call a page within a
> > particular frame.
> >
> > I have been working on a project where i a using HTML frames and SSRS is a
> > part of the right frame.i have to make sure that the URL
> > link(eg:-http://www.google.com) opens up in the right frame,and not in a
> > separate window.
> >
> > This is how i tried doing it.
> > 1.In a report i have put a image control.
> > 2.I go to the properties of the image, and go to "Navigation" tab and select
> > "Jump to URL" combo box and edit the expression.
> > 3.The expression that i have given is:-
> > ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> >
> > where fraRightFrame is the frame,in which want to open the URL.
> >
> > After i deploy this report and try clicking on the link, a page loads with
> > the message "Page cannot be displayed" and in the address bar, i can see the
> > above javascript.
> >
> > Please help me as to how i can call a URl in the same frame where the
> > report is running.
> >
> > Note:-
> > I am using SQL server reporting services 2005 with SP1 along with Shreapoint
> > server 2003.
> >
> > Waiting for your responce,
> >
> > Thanks in advance,
> > Regards,
> > Archana Kamath
> >|||Hi,
can you explain in detail how the script solved the problem.
I cannot see any different between the script that you posted in the first
post. both
seems to be the same. Can you please explain in detail how it solved the
problem.
Thanks
Bava
"Archana" wrote:
> Hi All,
> The script
> ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> worked fine.
> Many Thanks
> Archana
> "Archana" wrote:
> >
> > Please also note that Javascript works fine in the report.That is when i try
> > opening the report using the report manager /reportserver it works fine.When
> > i click the link, the page ('google') gets loaded.
> >
> > But when i include the same report in my sharepoint site ,using the page
> > viewer webpart and try accessing the link,it throws up an error saying "Page
> > cannot be displayed" and the javascript gets pasted on the address bar.
> >
> > Any idea why this behaviour?
> > Many thanks inadvance,
> > Regards,
> > Archana
> > "Archana" wrote:
> >
> > > Hi All,
> > >
> > > Please help me in using the hyperlinks in the SSRS to call a page within a
> > > particular frame.
> > >
> > > I have been working on a project where i a using HTML frames and SSRS is a
> > > part of the right frame.i have to make sure that the URL
> > > link(eg:-http://www.google.com) opens up in the right frame,and not in a
> > > separate window.
> > >
> > > This is how i tried doing it.
> > > 1.In a report i have put a image control.
> > > 2.I go to the properties of the image, and go to "Navigation" tab and select
> > > "Jump to URL" combo box and edit the expression.
> > > 3.The expression that i have given is:-
> > > ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> > >
> > > where fraRightFrame is the frame,in which want to open the URL.
> > >
> > > After i deploy this report and try clicking on the link, a page loads with
> > > the message "Page cannot be displayed" and in the address bar, i can see the
> > > above javascript.
> > >
> > > Please help me as to how i can call a URl in the same frame where the
> > > report is running.
> > >
> > > Note:-
> > > I am using SQL server reporting services 2005 with SP1 along with Shreapoint
> > > server 2003.
> > >
> > > Waiting for your responce,
> > >
> > > Thanks in advance,
> > > Regards,
> > > Archana Kamath
> > >|||Hi,
There was some problem in my sharepoint page and not in the script, which
was not letting the report to open in the specified frame.
What i did was,created a new sharepoint page with just one page viewer web
part and included the report in it which had the hyperlink and the script.
On click of the hyperlink,new page got opened in the same frame as required
by me,solving my problem.
Best Regards,
Archana Kamath
"Bava Mani" wrote:
> Hi,
> can you explain in detail how the script solved the problem.
> I cannot see any different between the script that you posted in the first
> post. both
> seems to be the same. Can you please explain in detail how it solved the
> problem.
> Thanks
> Bava
> "Archana" wrote:
> > Hi All,
> >
> > The script
> > ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> > worked fine.
> > Many Thanks
> > Archana
> >
> > "Archana" wrote:
> >
> > >
> > > Please also note that Javascript works fine in the report.That is when i try
> > > opening the report using the report manager /reportserver it works fine.When
> > > i click the link, the page ('google') gets loaded.
> > >
> > > But when i include the same report in my sharepoint site ,using the page
> > > viewer webpart and try accessing the link,it throws up an error saying "Page
> > > cannot be displayed" and the javascript gets pasted on the address bar.
> > >
> > > Any idea why this behaviour?
> > > Many thanks inadvance,
> > > Regards,
> > > Archana
> > > "Archana" wrote:
> > >
> > > > Hi All,
> > > >
> > > > Please help me in using the hyperlinks in the SSRS to call a page within a
> > > > particular frame.
> > > >
> > > > I have been working on a project where i a using HTML frames and SSRS is a
> > > > part of the right frame.i have to make sure that the URL
> > > > link(eg:-http://www.google.com) opens up in the right frame,and not in a
> > > > separate window.
> > > >
> > > > This is how i tried doing it.
> > > > 1.In a report i have put a image control.
> > > > 2.I go to the properties of the image, and go to "Navigation" tab and select
> > > > "Jump to URL" combo box and edit the expression.
> > > > 3.The expression that i have given is:-
> > > > ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> > > >
> > > > where fraRightFrame is the frame,in which want to open the URL.
> > > >
> > > > After i deploy this report and try clicking on the link, a page loads with
> > > > the message "Page cannot be displayed" and in the address bar, i can see the
> > > > above javascript.
> > > >
> > > > Please help me as to how i can call a URl in the same frame where the
> > > > report is running.
> > > >
> > > > Note:-
> > > > I am using SQL server reporting services 2005 with SP1 along with Shreapoint
> > > > server 2003.
> > > >
> > > > Waiting for your responce,
> > > >
> > > > Thanks in advance,
> > > > Regards,
> > > > Archana Kamath
> > > >|||Thanks for the reply.
"Archana" wrote:
> Hi,
> There was some problem in my sharepoint page and not in the script, which
> was not letting the report to open in the specified frame.
> What i did was,created a new sharepoint page with just one page viewer web
> part and included the report in it which had the hyperlink and the script.
> On click of the hyperlink,new page got opened in the same frame as required
> by me,solving my problem.
> Best Regards,
> Archana Kamath
>
> "Bava Mani" wrote:
> > Hi,
> > can you explain in detail how the script solved the problem.
> > I cannot see any different between the script that you posted in the first
> > post. both
> > seems to be the same. Can you please explain in detail how it solved the
> > problem.
> >
> > Thanks
> > Bava
> > "Archana" wrote:
> >
> > > Hi All,
> > >
> > > The script
> > > ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> > > worked fine.
> > > Many Thanks
> > > Archana
> > >
> > > "Archana" wrote:
> > >
> > > >
> > > > Please also note that Javascript works fine in the report.That is when i try
> > > > opening the report using the report manager /reportserver it works fine.When
> > > > i click the link, the page ('google') gets loaded.
> > > >
> > > > But when i include the same report in my sharepoint site ,using the page
> > > > viewer webpart and try accessing the link,it throws up an error saying "Page
> > > > cannot be displayed" and the javascript gets pasted on the address bar.
> > > >
> > > > Any idea why this behaviour?
> > > > Many thanks inadvance,
> > > > Regards,
> > > > Archana
> > > > "Archana" wrote:
> > > >
> > > > > Hi All,
> > > > >
> > > > > Please help me in using the hyperlinks in the SSRS to call a page within a
> > > > > particular frame.
> > > > >
> > > > > I have been working on a project where i a using HTML frames and SSRS is a
> > > > > part of the right frame.i have to make sure that the URL
> > > > > link(eg:-http://www.google.com) opens up in the right frame,and not in a
> > > > > separate window.
> > > > >
> > > > > This is how i tried doing it.
> > > > > 1.In a report i have put a image control.
> > > > > 2.I go to the properties of the image, and go to "Navigation" tab and select
> > > > > "Jump to URL" combo box and edit the expression.
> > > > > 3.The expression that i have given is:-
> > > > > ="javascript:void(window.open('http://www.google.com','fraRightFrame','height=500,width=400,left=0,top=0'))"
> > > > >
> > > > > where fraRightFrame is the frame,in which want to open the URL.
> > > > >
> > > > > After i deploy this report and try clicking on the link, a page loads with
> > > > > the message "Page cannot be displayed" and in the address bar, i can see the
> > > > > above javascript.
> > > > >
> > > > > Please help me as to how i can call a URl in the same frame where the
> > > > > report is running.
> > > > >
> > > > > Note:-
> > > > > I am using SQL server reporting services 2005 with SP1 along with Shreapoint
> > > > > server 2003.
> > > > >
> > > > > Waiting for your responce,
> > > > >
> > > > > Thanks in advance,
> > > > > Regards,
> > > > > Archana Kamath
> > > > >

Hw can the cube be modified after deployment?

Hi,

We used cube in our project.

And the project is released to production environment.

Now we need to modify the cube.

Can anyone have any idea what are the ways we can handle this?

Appreciate any suggestion.

Sachin!

If this is an SSAS2005 cube you will have a project in BI-Developer Studio? Open the project and make the changes and redeploy the script to the SSAS2005 server.

The other way is to reingeneer a deployed cube. BI-Dev Studio have a project for this as well: "Import Analysis Services 9 database". Once you have a new project you can start making changes.

HTH

Thomas Ivarsson

|||The third alternative is to connect online to the cube. In Visual Studio go to File -> Open -> Analysis Services Database, and you will end up making changes directly to the cube on the server without having to deploy the changes - just hitting Save will make the changes immediatelly.|||

But without a blueprint/copy of what you have done. You should always work with a project?

/Thomas Ivarsson

|||In online mode you still have a project - it's just online project - everything is on the server. It is ultimately up to the developer in which mode he wants to work. (BTW, in AS2000 the only available mode was online mode).|||

We have deployed product at many client locations.

Now we need to add few things to the cube

But it is not feasible to go and change manually at all locations and same time client may not want that.

We are looking after creating an update for the product.

Now the question is how to update cube? One option is delete existing cube and create again with new xmla script and process cube.

Can you please suggest any other way to do so?