Showing posts with label studio. Show all posts
Showing posts with label studio. Show all posts

Sunday, March 11, 2012

currency

How do i change the currency in visual studio for my reports. US is the only
one available.
any ideas?Not sure what you mean by changing the currency. During runtime, the Report
Server picks up the regional setting from the calling thread
(Accept-language HTTP header) and will format your currency accordingly. The
only thing that you need to do on your part is to use a neutral format
specifier - "C".
--
HTH,
---
Teo Lachev, MVP, MCSD, MCT
"Microsoft Reporting Services in Action"
"Applied Microsoft Analysis Services 2005"
Home page and blog: http://www.prologika.com/
---
"anon" <anon@.anon.com> wrote in message
news:e8yZ0gS5FHA.4012@.TK2MSFTNGP14.phx.gbl...
> How do i change the currency in visual studio for my reports. US is the
> only one available.
> any ideas?
>

Thursday, March 8, 2012

Cubes and .Net applications

What are the pros and cons of accessing the data in a cube through a visual studio 2005 .net application?Are you referring to a .NET 2.0 application (since Visual Studio 2005 is a development environment) - if so, that's rather an abstract question? Could you provide more specifics of the application usage scenarios you have in mind?|||Yes, I am referring to a .NET 2.0 application. Normally, our .NET application uses a webservice to runs sqls to retrieve data for reports in the application. I would like to know what is involved in retrieving data from the cube using a webservice. Is it more involved? Are there any benefits or risks to using a cube to retrieve data for a report in a .NET application versus just using DB2 databases? We currently retrieve our data from DB2 databases.

Wednesday, March 7, 2012

Cube won't process in SSIS, but will process thru Mgmt Studio?

Hello,

SSAS newbie here. I have an AS database called "AS_Sales" with numerous cubes, including one called "CP Sales". It has one measure group (also called "CP Sales") that is partitioned by fiscal quarter.

I can right-click the cube in management studio and hit "Process" and it indicates that everything completes successfully. However, I set up an Analysis Services task in SSIS to do the same thing, and I receive errors.

SSIS package consists of two AS tasks -- Refresh Dimensions & Reprocess Cube. The task fails during the dimension reprocessing, with the following error messages:

Information: 0x40016041 at AS_Sales_Cubes_Refresh: The package is attempting to configure from the XML file "E:\SSIS\Config\AS_Sales_Cubes_Refresh.dtsConfig".

SSIS package "AS_Sales_Cubes_Refresh.dtsx" starting.

Error: 0xC11F000E at Rebuild Dimension Structure, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: An error occurred while processing the 'FY2001_QTR4' partition of the 'CP Sales' measure group for the 'CP Sales' cube from the AS_Sales database.

Error: 0xC11F000E at Rebuild Dimension Structure, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: An error occurred while processing the 'FY2003_QTR3' partition of the 'CP Sales' measure group for the 'CP Sales' cube from the AS_Sales database.

Error: 0xC11F000E at Rebuild Dimension Structure, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: An error occurred while processing the 'FY2005_QTR2' partition of the 'CP Sales' measure group for the 'CP Sales' cube from the AS_Sales database.

Error: 0xC11F000E at Rebuild Dimension Structure, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: An error occurred while processing the 'FY2007_QTR3' partition of the 'CP Sales' measure group for the 'CP Sales' cube from the AS_Sales database.

Error: 0xC1060000 at Rebuild Dimension Structure, Analysis Services Execute DDL Task: OLE DB error: OLE DB or ODBC error: Operation canceled; HY008.

Error: 0xC11F000E at Rebuild Dimension Structure, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: An error occurred while processing the 'FY2005_QTR4' partition of the 'CP Sales' measure group for the 'CP Sales' cube from the AS_Sales database.

Error: 0xC1060000 at Rebuild Dimension Structure, Analysis Services Execute DDL Task: OLE DB error: OLE DB or ODBC error: Operation canceled; HY008.

Error: 0xC11F000E at Rebuild Dimension Structure, Analysis Services Execute DDL Task: Errors in the OLAP storage engine: An error occurred while processing the 'FY2006_QTR1' partition of the 'CP Sales' measure group for the 'CP Sales' cube from the AS_Sales database.

Task failed: Rebuild Dimension Structure

SSIS package "AS_Sales_Cubes_Refresh.dtsx" finished: Failure.

It only seems to be failing for a handful of the partitions, which makes the problem all that more confusing. Does anyone have any ideas about what I'm doing wrong?

Thanks in advance,

Jamie

if you have defined your attribute relationships as rigid you cannot use refresh for your dimensions. Try full process of each dimension and see what happens. Place the processing(full) of the dimensions before processing the cubes/measure groups.

HTH

Thomas Ivarsson

Cube processing error: "The end of the input was reached"

I created a cube with AMO and examined it in BI Studio by importing. Everything looks fine, but I get the following error when processing the cube:

"Parser: The end of the input was reached".

The processing of dimensions appears to be successful. SSAS processes the cube immediately after finishing dimensions. That's where the error occurs. What is odd is that the process progress dialog box shows everything was completely successfully. I am quite sure that the processing of the cube was not completed because I cannot browse it and I know it takes much more than a duratio of 0 seconds to process the cube.

Could anyone offer some hint?

Thanks,

hz

It looks like the script you have for your cube contains syntax error. At least it should have "CALCULATE;" statement.
|||

I did not write the script. I wrote code in C# using AMO to create the cube. I do not know how to look at the script, but scripted the cube to a query editor window and did not see any CALCULATE statement. I also scripted a cube that is working perfectly and did not see CALCULATE in its script either.

At this point of time, I am temporarily giving up using AMO to create cubes and resorting to other means.

hz

Friday, February 24, 2012

Cube browsing for endusers

Hi all,

Browsing a cube using SQL server management studio and Analysis servcices project is possible. Is there any possibility to have custom application built to have the option of browisng without opening Studio management or analysis services project?

Purpose of this is simple. End user should simplay have measures and dimensions and he will just drag and drop in to the browse area.

One thing I really like about Microsoft is that almost anything is possible . Programming one cube/dimension browser yourself is quite an interesting task. I'd use AMO to get the cube and it's dimensions structures, and then I'd use those to build up MDX queries when the user drags-n-drops. To enumerate the cube and dimensions is very easy using AMO. The hard thing here is to convert the drag-n-dropping into well formed and accurate MDX. Like did they drop on columns, rows, as a filter etc? Which hierarchy and level did they expand/drill down?

Some resources:

Query using C#: http://www.devhood.com/tutorials/tutorial_details.aspx?tutorial_id=640

AS objects: http://technet.microsoft.com/en-us/library/ms124924.aspx

There is a good example on how to enumerate an OLAP db in the SQL Server samples, which can be downloaded here:

http://www.microsoft.com/downloads/details.aspx?familyid=e719ecf7-9f46-4312-af89-6ad8702e4e6e&displaylang=en

After installation the AMO browser is located at c:\Program Files\Microsoft SQL Server\90\Samples\Analysis Services\Programmability\AMO\AmoBrowser\

Else there is this ProClarity browser which allow end users (say management) to browse a cube in an intuitive way, but that one costs $$$.

Cube Browser not filtering the data for the user having only read definition permission

Hi,

I am started working with SAS2005 recently. Using Adventure works sample database.

When I login to the Management Studio as administrator and browse the cube, the browser filters all the null value columns and rows.

Steps:

1. Add Product.Product Categories to filter area and select only Bikes

2. Add Date.Calendar.Date Calendar year to filter area and select year 2005

3. Add Product.Product to Row area

4. Add Measures.Internet Sales.Internet Sales Amount in the Total or detail area

5. Add [Date].[Month of Year] in the column area.

When I logged in as administrator or the user with the role Full control (administrator) and all the nessasary permission set on all the objects. The cube browser displays the data where only it has values. If the entire row or column are null then the row and columns are not displayed.

When I do the exactly same with the user has a role instead of full control using just read definition option (I do not want the user to get full permission, like to make a role as read only) , the browse cube shows all the rows and columns, even the row and columns where all the values are null.

The empty cells are displayed as #N/A.

Is it possible to make the browser behave for the read only user as exactly like administrator user.

Any suggestions and recommendations are great.

Thanks

I am stuck with this problem. Please somebody help...

Cube Browser FAILS to open. It HANGS

Hi, I am working on the Analysis Services Tutorial.

When I am in Business Intelligence Studio and I right-click on the cube and I choose browse to open the cube-browser, the Cube-Browser HANGS FOREVER. it never finishes opening. I always end up using the taskmgr to kill off Business Intelligent Studio. How is this HANGING problem fixed?

AIMDBA

The Event Viewer Applicaiton log is showing the following:

Hanging application devenv.exe, version 8.0.50727.42, hang module hungapp, version 0.0.0.0, hang address 0x00000000.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

Fault bucket 230214627.

For more information, see Help and Support Center at http://go.microsoft.com/fwlink/events.asp.

AIMDBA

|||

Try to see if re-installing Analysis Services will solve the problem.

Edward.
--
This posting is provided "AS IS" with no warranties, and confers no rights.

Ctrl+Tab not working

Having an issue with the navigation keys. When I first installed Studio I could Hold Ctrl and tab through the active windows, then on releasing the buttons I would move to that active window. Now when I press Ctrl+Tab the list will come up, but wont jump to the screen I end on. The quick link window will stay up and the only way I can transfer windows is hitting Enter or clicking on the desired window with my mouse. Any ideas on this "seemingly simple" issue. I went through all of the Tools -> Options window with no luck.Moving to the tools group.