OLAP Drillthrough For Null Data

Mar 31, 2004

Hi:

The drillthrough in my cube is working fine except for the cases where the dimension member is null. For example I have the dimension
PRODUCT (dim)
- PROD_TYPE_CD (name = PROD_TYPE_CD || '-' || PROD_TYPE_NM)
- PROD_CD
-PROD_NM

So for if the data is like the following where the PROD_TYPE_CD is null :
- (name = -FOOD)
- 123
- bread

The drillthough is not displaying any data no matter I select the PROD_TYPE_CD, PROD_CD or PROD_NM in the dimension drop down altough if query the DB directly I found data to display in the drillthrough
Any ideas why this is happening and how to solve it.

Thanks
J

View 1 Replies


ADVERTISEMENT

Drillthrough Question - How To Return To Same Report Page Where Drillthrough Occurred?

Apr 10, 2007

Hello,



I have a master report that uses the "Jump to report" property to drill through to a detail report when the user clicks a report column value. This all works great and the users love it. However, when I click the brower's "Back" button to return to the master report, the master report is rerun and I am returned to page 1. If I drilled through on page 25 of the master report then I have lost my original position and I must navigate back to page 25. The users don't love this "feature"!



Is there a way I can return from the drill through detail report to the master report without using the browser's back button and losing my original position in the master report?



Thanks,

BCB



View 1 Replies View Related

Drillthrough In Calculated Fields Enable When Drillthrough Option Is Disable In Original Fields, Is This A BUG?

Jan 21, 2008

Hi people
My users are having troubles with link to default drillthrough report when reports are exported to excel (they REALLY don't like this behavior ), so I decided set all of them disabled in report model, this work fine, but calculated field in reports has this drillthrough link.


Let me show you the situation. Entity Product has an UnitaryCost field, I set the EnableDrillthrough Property in False so when I export a report with this field, no link is shown.

But if I create in the report a calculated field Round(UnitaryCost) this field has a Drillthrough Link

Is this the standard and expected behavior? or its simply a BUG?

Have I done something wrong in my model? and in this case, How I can correct this?

regards.
Julio Diaz.

View 1 Replies View Related

Drillthrough Shows Other Data Than SQL Server

Oct 25, 2007

Hello!

I'm working with the SQL Server 2005 Developer Edition. When i created a mining structure for association rules and go into the rule by drillthrough there's something i don't understand.

In the SQL Server the data set is:

ID: MM: MF:
47 463 200

And drillthrough shows me:

ID: MM: MF:
47 476 227

Why is the result of drillthrough another than in the table of the SQL Server???

View 1 Replies View Related

OLAP Services: Automating Archival/Restore Of OLAP Databases

Sep 19, 2000

Hello All,

Our OLAP environment involves an ETL/Data Warehouse/Data Mart server and a cube publisher server.
We would like to learn how to automate the Archival/Restore of OLAP databases. We are currently doing
it manually though OLAP Manager. Any help would be appreciated. Thanks. James.

--
James E. Bothamley
Senior Database Administrator
Dave & Buster's, Inc.
2481 Manana
Dallas, TX 75220

Work
Phone (214) 904-2296
email jbothaml@DaveAndBusters.Com

"Once in a while you can get shown the light
in the strangest of places if you look at it right"

JG 1942-1995 RIP

View 1 Replies View Related

On The Subject Of Data Warehouses, Data Cubes && OLAP&….

Jul 20, 2005

On the subject of Data Warehouses, Data Cubes & OLAP….I would like to speak frankly about Data Warehouses, Data Cubes andOLAP (on-line analytical processing). Has it dawned on anyone elsethat these buzz words were created by some geek who decided to take astab at marketing? Knowing that to the backwoods manager who knowslittle of technology that new innovative names for old concepts wouldhelp to sale their products.I mean seriously, what is the story here? In a nut shell, and pleasestop me if you disagree, but isn’t a data warehouse simply adatabase? Can’t you do everything on a conventional databaselike SQL Server, Oracle or DB2 that you can do on these newproprietary Data Warehouse constructs? I mean who are they trying tofool?Take a look, for instance, at Data Cubes. Who hasn’t noticedthe striking similarity between data cubes and views used in all themore robust databases? Also, what about OLAP? OLAP is nothing morethan a report generator. There’s nothing you can do with thesemillion dollar price tagged Data Warehouse total solution packagesthat I can’t do with SQL Server, Oracle or DB2…for thatmatter Microsoft Access.As an example some sales people for Metadata Corporation has the VicePresident of I.T. in Nashville, for Healthspring, sold on their totalsolution data respository which is such a scam. All they had to dowas throw a couple of buzzwords at him and they have him hypnotized.Personally, I feel that these kinds of marketing practices undermineour industry. It helps to unravel what little standards orconsistency we have. What do you guys think?Stuart

View 7 Replies View Related

How To Repair A Corrupted OLAP Database? (was Olap!:)

Jun 12, 2007

How to repair a corrupted OLAP database?

View 2 Replies View Related

DSN Data Source For OLAP

Jun 5, 1999

I am starting using OLAP service. The first problem the first day I use it.

I setup a system DSN for OLAP under ODBC source. I use SQL driver to create a data source to a SQL server. I am using SQL SA login account. Then I go into OLAP manager create database. Then in the library I set up a data source using the DSN I created before.In the General Tab I use OLE DB for ODBC provider. After this I try to create a new cube using the wizard. I got error the message that the SQL login is invalid. I double check it is right login account. I failed several times. Then I tried directly create data source under library and not using the DSN I created before. The first time it failed again has the same message. Then the second time when I create data source I use NT authentication instead SQL login. Now everything went fine. I was able to create a cube. But I still wondering what is preventing using SQL login account when creating data source.

Thanks for the help

View 1 Replies View Related

OLAP And/or Data Mining?

Jul 20, 2005

Hello,If I wrote the next ebay (yes I know, yawn-snore) and I had a databasewith 5 million auction items in it, what would be a really goodstrategy to get a search done very quickly? Would it involvesomething called OLAP and/or "data mining"? The only technology I amfamiliar with is simply SQL Server databases with stored procedures.I think I'd be guessing correctly and say that this technology simplywouldn't be fast enough *on it's own* to do super fast queries againstmassive amounts of data.Any insights would be of great interest. Thanks.-Frameworker.

View 5 Replies View Related

Export Olap Cube Without Data

May 31, 2005

Is any way to export and import an olap cube whithout his data?

Tks!
Paul

View 1 Replies View Related

Pull Olap Data Using SQL Commands?

Jul 28, 2004

I have an OLAP server and would like to use my Chart FX software without having to purchase the OLAP extensions on the server due to budget restraints (ouch).

I've heard that it is possible (although limited) to attach toan OLAP cube using SQL select statements (not MDX).

Basically, I would like to pull the OLAP data in the relational sense.

Is this possible? If so, are any good articles on this subject?

I'm new to OLAP and would like to transition slowly.

Thanks in advance :)

View 1 Replies View Related

OLAP Report Data Source

Apr 29, 2008

I prepared an OLAP cube for the report data source in the SSAS 2005. The OLAP cube consists of more than 20 dimensions and several measure groups. I then created the subset/view of the OLAP cube using the "Prepective" function and limit to not more than 7 dimensions on each of the subset. How do I reference the OLAP cube subset as the data source when developing the report in the report designer. Furthermore what is the advantage of creating multiple smaller OLAP cubes with less dimensions comparing to one big OLAP cube with several subset/view attached to it. Thanks.

View 3 Replies View Related

Accessing OLAP Data From SSIS

Feb 12, 2007

After reading some threads on this forum about accessing OLAP data from SSIS via an OLE DB Source component (and trying it myself and getting that "pcrsstore.cpp line 325" error), I have worked around the problem by using a Script Task component.

This calls a .NET assembly I wrote that uses ADOMD.NET to get at the data using an MDX query, and then actually posts an event to a Notification Services instance via a stored proc.

Writing, deploying, and maintaining a .NET assembly is more than I wanted to do, but it was worth the effort since now I know a little about extending SSIS when I need to.

But what I really wanted to do was the following, all from within the core components of SSIS:


Import my OLTP data into my relational warehouse (already done using SSIS)
Process the cube (already done using SSIS)
Access the cube via MDX and post an event to Notification Services
It's this last step that needed some special work because of SSIS's apparent limitation accessing cube data (although posting the event to NS would be easy because SSIS can call a stored proc on the NS application database).
So I'm hoping that a future release or service pack of SSIS will give us some components to run MDX and get the OLAP data into the pipeline as if it were from any other source.
Thanks for reading, and if anyone has any suggestions on a better way to achieve what I need please let me know!
-Larry

View 2 Replies View Related

Extracting Olap Data Into SQL Using SSIS

Apr 2, 2008

I am using data flow task.And data flow source uses ole db for olap 9.0 to connect my ssas. sql comment is my access mode. A mdx query extracts data. Data flow destination is sql server table. Error said Data Flow Task: OLE DB Source [579]: The output "OLE DB Source Output" (589) references an external data type that cannot be mapped to a Data Flow task data type. I guess it is a implicit data type convertion problem. But how to solve it???

I appreciate for all suggestion. Thanks.

View 6 Replies View Related

OLAP Server Returns Incorrect Data

May 24, 2001

I'm working with PivotTable on Excel 2000 which is connected to an OLAP server (from SQL Server 7 installation). The pivot is intended to analyze Sales during April 2001. Yesterday I found out that OLAP/Excel returned/displayed inconsistent data. The 'April Total' value is NOT equal to the 'Quarter 2 Total' (I already inspected the underlying database and sure that there is absolutely NO data for months after April 2001). The value for 'April Total' is the correct one. I'm not sure whether the problem resides on the OLAP Server or Excel (pivot) itself. For ones who like to help me I would be glad to supply you with the screenshots (just email me).
Please help.

Regards

Dave

View 1 Replies View Related

Error Returning OLAP Data In RS 2005

Mar 28, 2006

I have a .rdl file that was exported out of ProClarity's Desktop Professional 6.1 using their RS plug-in. I uploaded the file into Report Manager and when I execute it, I get the following error:


An error has occurred during report processing.


Query execution failed for data set 'Three_Month_Funding_Trend'.
Unable to recognize the requested property ID 'ReturnCellProperties'.











Does anyone have any idea what this is referring to? Does it have something to do with my configuration, connection or the report definition? Other reports such as DBMS based reports work fine.



Thanks for your assistance

View 11 Replies View Related

Lift Charts With OLAP Data Source

Nov 29, 2006

I've generated some mining models against an OLAP data source (dimension). However, when I go to generate a lift chart, it seems that the only data source that can be used for input is the data source view (the relational database). Is that right? Or is there something I'm missing here.

I was figuring I'd use one slice to train the model, then another slice to test the accuracy of the results. But right now it's looking like I can't do that.

View 3 Replies View Related

Analysis :: OLAP CUBE And Data Sources

Aug 4, 2015

I've

1. SQL Server Data Warehouse
2. OLAP CUBE in Analysis Services

My question is - If my SQL Server Data Warehouse is changed (Having Append Data) - Is that My OLAP Cube will have the Append Data?

It's possible, my OLAP Cube always having Append Data if my Data Warehouse is changed? If yes, how to do it without re-deploy and re-process my Analysis Services Project.

View 3 Replies View Related

SQL Server 2008 :: OLAP CUBE And Data Sources

Aug 3, 2015

I've

1. Data Warehouse
2. OLAP CUBE in Analysis Services

My question is - If my Data Warehouse is changed (Having Append Data) - My OLAP Cube will have the Append Data?

It's possible, my OLAP Cube always having Append Data if my Data Warehouse is changed? If yes, how to do it without re-deploy and re-process my Analysis Services Project....

View 2 Replies View Related

Analysis :: OLAP Cube Data Visualization Tools For Desktop?

Jun 5, 2015

I am looking for some Simple/Best Data Visualization tools for Desktop which accept data from SSAS Cubes.

View 5 Replies View Related

Reg:SSIS Package To Transfer Data Between SQL Table And Olap Cube

Apr 2, 2008



Hi All,
can anybody help me in creating the SSIS package to transfer the data from SQL table in database engine to OLAP cube in Analysis services


Thanks in Advance.
Archana

View 1 Replies View Related

OLTP Vs OLAP (Data Warehouse) As A DataSource In Analysis Services 2005

Jul 3, 2007

Hello,Can I import an OLTP (Reltional DB) as a Data Source into SQL ServerAnalysis Services 2005 and then use the Cube Wizard and the new DataSource View feature to create the OLAP model ?Or do I have to first design an OLAP Data Warehouse with a Star Schemaand then import this DW as a Data Source into my Analysis ServicesProject.With SQL Server 2000 , OLAP would be the way to go..but with SQLServer 2005 , it seems as though the wizard and data source viewfeatures do half the work for you.I have an OLTP DB and am not sure which route I should take ! Anysuggestions / input would be much appreciated.Thanks in Advance...RegardsRusszee

View 1 Replies View Related

SSIS Package To Import Data From SQL Datasource To Datawarehouse OLAP Cube

Apr 8, 2008

Hi All,

I have created database and OLAP cube in Analysis services using SSAS.In SSAS I have used a datasource which is using SQL tables to populate OLAP cube.Now when I added some more data to my SQL tables and trying to deploy cube,the newly added is not getting populated in the cube.So i want run SSIS package which will import data from SQL tables to this OLAP cube.

Can you please help me how to write this SSIS package to import data from SQL tables to OLAP cube.(Very urgent issue)

Thanks in Advance,
Swapna

View 4 Replies View Related

Drillthrough

Mar 27, 2007

I am a confused newbie, grateful for some help. I need to select 10 rows from total profit of married people. How would I do that?


DRILLTHROUGH MAXROWS 10 SELECT
{[Measures].[Total Profit]} on 0, [customer].[Name]ON 1 ON columns
FROM from [Electronics] WHERE [Demo].[civilstatus-salary].[civilstatus].&[married]}
RETURN [Measures].[Total profit](as rows)

View 2 Replies View Related

Drillthrough (beginner)

Jan 5, 2007

I have created two reports. One links to the other with a drillthrough. The linking works fine, but no values show up in the fields besides the group titles and column titles. Why is this happening?

The user is given a list of Counties with values. The Counties(in a matrix) are clickable for a drillthrough of Ages and Genders in the Counties. Looks something like this:

Years

Counties Total Crashes Fatalities

Cook 85 98

Manchester 2850 258

Sagamon 987 526



So when a user clicks a county, such as "Cook", this is displayed

Years

Age Gender Total Crashes Fatalities

0-8 Female 25 8

Male 55 15

9-15 Female 850 258

Male 185 35

16-22 Female 87 526

Male 10 35



But I am getting this in :

Years

Age Gender Total Crashes Fatalities

0-8 Female

Male

9-15 Female

Male

16-22 Female

Male



Whats going on? Can anyone make any suggestions? Just to let you know its based off of an Analysis Services Cube and not relational tables.

View 2 Replies View Related

Can You Have A Drillthrough If Your Using An AS Cube

Jan 11, 2007

Trying to drillthrough one report to another. But im not getting the correct values. I dont know why its not working. I created the parameters and linked them in the properties of the clickable field. What am i missing? or is it more complex in a cube to drillthrough then relational tables?

View 3 Replies View Related

Want The Parameters To Appear ON The Drillthrough Report

Nov 29, 2007

Hello again,

We have a drillthrough report that our users will see as part of an ASP.net page. I would like to nicely show the parameters that were sent through from the main report, maybe in a text box of some kind. However, when I set a text box value to =Fields!FieldName.value, I get the tuple: [Dimension].[Hierarchy].&[Member]. I just want the Member.

I know I can parse out the value, but is there any easier way that I'm missing. We aren't using the parameter bar that comes with RS, we want the report itself, above the matrix with the data, to show the parameters.

Any ideas, resources, references, links or good clean jokes would be appreciated.

Thanks,
Kathryn

View 2 Replies View Related

Permission Error On Drillthrough

Jun 27, 2007

I've published a matrix type report through report builder to my report server, based on the model I created. When I click the subtotals to drillthrough, I receive the following error:



"The permissions granted to user 'Domainuserid' are insufficient for performing this operation. (rsAccessDenied)"



If I explicitly specify another report to tie to the drillthrough property on the entity via the model property page in SSMS, the drillthrough stuff works fine. But if I just rely on Reporting services to auto generate ( see "Autogenerated" here ) the clickthrough report I get the error above. Can anyone help?

View 1 Replies View Related

Drillthrough Help In Report Builder

Jan 8, 2007

Hi,

I've looked at all of the published materials related to this subject that I could find but cannot find a good answer.

I'm trying to find out if there is a way to directly influence what details are shown when a figure is clicked on in a report.

I know it shows related data but it does not seem to show it all, infact it seems to pick pretty arbitrary things.

I've tried messing around with the attribute properties (in particular the EnableDrillthrough one) but to no avail.

Is there anything I am missing?

Thanks in advance.

View 4 Replies View Related

How Can I Drillthrough To Reports In Another Project

May 2, 2007

I'm trying to use the drill-through feature to link to a report in the same solution, on the same server, but in a different project. Local help files say:



"The list of report names includes all reports in the current report server project. If the drillthrough report is on the report server but is not in the project, type the name of the report. The report name can contain a relative or absolute path to the report."



Can someone give an example of a relative or absolute path? Nothing I've tried has worked.



Thanks,

JL

View 5 Replies View Related

DRILLTHROUGH In Report Server

May 21, 2007



Dear all,



Please help to create DRILLTHROUGH in a report server project. I am a beginner . I want the DRILLTHROUGH featrure in Report server like same as that of analysis server project





Please help



regards

Polachan

View 3 Replies View Related

Drillthrough Missing Rows (AS 2005)

Jun 27, 2007

I have enabled drillthrough on a cube (AS 2005) and selected the columns required. This worked. When I use the drillthrough option in Excel, drillthrough queries return less rows than expected. For example, for a cells combinations (pivot table) I saw 21198 rows, but after access to detail, query return just 21106 rows. Less rows than expected.

Any ideas what causes this?

Thanks!

:)

View 1 Replies View Related

Drillthrough Report Link Not Working

Oct 25, 2007

Good morning all!

I am working on a Actuals vs Budget report which needs drillthrough capability. Right now the reports are not deployed, I am working on them in Visual Studio 2005.

My main report has a text box with the Navigation tab set to Jump to report: DrillThrough1025. I have set all the parameters to pass through to the drill through report.

When I preview my main report and click on the drillthrough textbox, the DrillThrough1025 Report opens, but it opens with the parameter bar at the top, waiting for the parameters to be filled in.

Am I making a basic newbie error somewhere?

Any ideas, references, or resources would be greatly appreciated.

Thanks,
Kathryn

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved