Problem in Drillthrough report

Hi Friends,

I am very new to MSSQL Reporting service 2005. I wanted to create a drithrough report. I have created a master report using a cube created using MSSQL Analysis service 2005. The master report contains a column called 'Territory', which details some other columns also. My child report contains the same 'Territory' column, but with displays some other detailed information. If I click on the territory column data on master report, it should take me to child report where it should show only Territory which matches with the master territory.

I have created both master & child reports. In my master report, Jump to Report, I have given the name of my child report. In my child report, if I have created a hidden parameter by providing available value through query. But while clicking the territory column master report I'm getting error parameter xxx is missing a value. If I uncheck as hidden parameter it pops up for the value & it works.

How to go about it, can someone help?

Thanks & Regards,

Naveen J V

Hi,

Its a long time ago as I had built my last report - but at the Jump to Report there is also a part where you map the Target Report Paramter to something of your current Report. There you have to specify the value for Target Report Parameter - your current Territory.

If you not specify the paramters it get set to the default parameter of null - which seems to be not allowed for your parameter.

It looks like this is more related to report server - I recommend you to post your question there if my hint does not help.

Mabe someone from MS moves it to the report server forum.

Best Regards

Hannes

Problem in deployment on SSAS 64 bit with Oracle 10g 32 bit client (as datasource)

Hi,

I installed SQL Server 2005 64 bit and have Oracle 10g 32 bit client,
I am creating a cube based on Oracle datasource by connecting Oracle 10g 32bit client.

when I build and process cube it Done successfully but when I deploye it to server then it gives following error.

Error 1 Errors in the high-level relational engine. The following exception
occurred while the managed IDbConnection interface was being used: Attempt
to load Oracle client libraries threw BadImageFormatException. This problem
will occur when running in 64 bit mode with the 32 bit Oracle client
components installed.. 0 0

Error 2 Errors in the high-level relational engine. A connection could not
be made to the data source with the DataSourceID of 'Oracle DW Call Detail',
Name of 'Oracle DW Call Detail'. 0 0

any suggestion regarding this ?

Hi Kawish,

Did you solve this prolem? I am having the same problemss as you describe here.

look forward to hearing from you..

Problem in creating reports using BI fields

Hi,

I have created a cube using 3 Dimensions and 1 measure. One of the dimensions is a time dimension. I have also used the ADD BI command to get the Year to Date and Year over year % . This works perfectly with the cube. But when I try and create a report I am unable to display the figures for the above mentioned columns. I get Null data there.

Does anybody have any suggestions as to why this is happening and what the way to overcome this.

Thanks in advance
MNJ

Could you provide more information on how you are creating the report and which columns are returning nulls?

Problem in creating reports using BI fields

Hi,

I have created a cube using 3 Dimensions and 1 measure. One of the dimensions is a time dimension. I have also used the ADD BI command to get the Year to Date and Year over year % . This works perfectly with the cube. But when I try and create a report I am unable to display the figures for the above mentioned columns. I get Null data there.

Does anybody have any suggestions as to why this is happening and what the way to overcome this.

Thanks in advance
MNJ

Could you provide more information on how you are creating the report and which columns are returning nulls?

Problem in creating reports using BI fields

Hi,

I have created a cube using 3 Dimensions and 1 measure. One of the dimensions is a time dimension. I have also used the ADD BI command to get the Year to Date and Year over year % . This works perfectly with the cube. But when I try and create a report I am unable to display the figures for the above mentioned columns. I get Null data there.

Does anybody have any suggestions as to why this is happening and what the way to overcome this.

Thanks in advance
MNJ

Could you provide more information on how you are creating the report and which columns are returning nulls?sql

Problem in browsing cube and dimension data

I have SQL Server 2000 installed on Windows 2000 Advance Server. On same machine I installed MS Analysis servise. By default Analysis service have FoodMart2000 database which have some cubes and dimension. When I right click on cube and browse the data, it open the data browsing window and following message display

"Unspecified error unable to browes the data"

So please solve my problem and what can i doKnown problem, see 873440
This is typically caused by either not having SP4 installed or installing Office after SQL Server.

_-_-_ Dave

Problem in browsing cube and dimension data

I have SQL Server 2000 installed on Windows 2000 Advance Server. On same machine I installed MS Analysis servise. By default Analysis service have FoodMart2000 database which have some cubes and dimension. When I right click on cube and browse the data, it open the data browsing window and following message display

"Unspecified error unable to browes the data"

So please solve my problem and what can i doKnown problem, see 873440
This is typically caused by either not having SP4 installed or installing Office after SQL Server.

_-_-_ Dave

problem getting right properites

I'm having problems getting the right properties out.
I get the launch date in a column, but that overwrites
with the cube like, [Zone Id].[A].[B].[C]
it inserts the launch date, where the C column should be. In the 2nd query
below, I can get both the date and the value of C, but it gives me double
the rows, and it's in the same column. 'launch date' is a property of [C]
WITH
SET ld AS 'CreatePropertySet([Zone Id].&[14].&[74], [Zone].[Zone
Id].&[14].&[74].children,
[Zone].CurrentMember.Properties("launch date"))'
SELECT {[Measures].[data1],[Measures].[data2]} ON COLUMNS,
{[ld]} DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_KEY
ON ROWS
from [All Data]
--
If I use this query, I get double the rows.
WITH SET Top5 AS
' Descendants( [Zone Id].&[14].&[74], 1)'
SET ld AS 'CreatePropertySet([Zone Id].&[14].&[74], [Zone].[Zone
Id].&[14].&[74].children,
[Zone].CurrentMember.Properties(" launch date"))'
SELECT {[Sends],[Measures].[S Sends]} ON COLUMNS,
{[Top5],[ld]}
ON ROWS
from [All Data]sorry I found it, I just gotta add
DIMENSION PROPERTIES [Zone].[Campaign Launch Date]
"Cindy Lee" <cindylee@.hotmail.com> wrote in message
news:Odi1UoD%23EHA.2596@.tk2msftngp13.phx.gbl...
> I'm having problems getting the right properties out.
> I get the launch date in a column, but that overwrites
> with the cube like, [Zone Id].[A].[B].[C]
> it inserts the launch date, where the C column should be. In the 2nd
query
> below, I can get both the date and the value of C, but it gives me double
> the rows, and it's in the same column. 'launch date' is a property of [C]
> WITH
> SET ld AS 'CreatePropertySet([Zone Id].&[14].&[74], [Zone].[Zone
> Id].&[14].&[74].children,
> [Zone].CurrentMember.Properties("launch date"))'
> SELECT {[Measures].[data1],[Measures].[data2]} ON COLUMNS,
> {[ld]} DIMENSION PROPERTIES MEMBER_CAPTION, MEMBER_KEY
> ON ROWS
> from [All Data]
> --
> If I use this query, I get double the rows.
> WITH SET Top5 AS
> ' Descendants( [Zone Id].&[14].&[74], 1)'
> SET ld AS 'CreatePropertySet([Zone Id].&[14].&[74], [Zone].[Zone
> Id].&[14].&[74].children,
> [Zone].CurrentMember.Properties(" launch date"))'
> SELECT {[Sends],[Measures].[S Sends]} ON COLUMNS,
> {[Top5],[ld]}
> ON ROWS
> from [All Data]
>
>

problem getting refreshed data while accessing the cube from excel(OWC)

If I save a report using a cube in an excel spreadsheet, the next time when I open it, and try to drag a dimension, I cannot see any data. I need to refresh the document every time

I process the cube.

Is there way we can automatically refresh these reports ? Has anyone had this problem

before?

I'll appreciate your help.

thanks,

Rok

In 2007, you can configure your connection to refresh data everytime the file is opened or on a fixed interval. In 2003, this appears as a Pivot Table option.

B.

Problem Excel as OLAP Client with large volume of data

Dear all,

I am using Excel 2000 as my OLAP cube cleint. It's flexible and user friendly when I need to retrive data from cube. However, I am having problem when I need to retrive large volume of data from cube to the excel report (i.e: bank & finance report).

I tried link server but it doesn't make much different.

Can anyone tell me how to solve the problem, if I could only use excel or other license free application as my OLAP Client.

Thanks!

regards,
SamYou didn't mentioned about the problem you're having i.e., Performance related or query based.

If its performance based what is the current configuration of server and database information.

problem editing dataset mdx query sql 2005

Hi all,
I have created a report with the report wizard. I used a cube as a
datasource.
After creating I also run the report without any problems.
However when I go to the data tab to edit my dataset.
The dataset becomes empty and my reports is getting errors like
"Report item expressions can only refer to fields within the current
data set scope or, if inside an aggregate, the specified data set
scope"
What is the problem, why can't I change a dataset based on analysis
services, i don't have any problems with datasets based on normal
databases.In Short:
WORKAROUND: If you have created your report using the Report Wizard to start
the MDX Query Builder, open the .rdl file as XML. Find the section starting
with <rd:MdxQuery> and ending with </rd:MdxQuery> and delete all spaces and
newlines between elements (between closing > and opening <) so the whole
complex element is inline. You will be able to continue working with the
report normally.
1) The problem arises when you use the Report Wizard (as GaryV indicated
before me)
2) If you compare the XML generated by the Query Builder when using the
Report Wizard and Add existing item... you will see
a) the complex element <rd:MdxQuery> from the Wizard path is nicely
formatted with spaces and newlines while
b) the Query Builder used directly puts the whole long
<rd:MdxQuery></rd:MdxQuery> "subdocument" inline
c) the proof is in the pudding - if you delete the formatting characters (I
ssupect the inlines are key) you can tab to Data and edit the dataset w/o
problems
See thread " VS crashes when ..."
"Anke" <anke_ruigrok@.zonnet.nl> schrieb im Newsbeitrag
news:1134563578.098538.277750@.g49g2000cwa.googlegroups.com...
> Hi all,
> I have created a report with the report wizard. I used a cube as a
> datasource.
> After creating I also run the report without any problems.
> However when I go to the data tab to edit my dataset.
> The dataset becomes empty and my reports is getting errors like
> "Report item expressions can only refer to fields within the current
> data set scope or, if inside an aggregate, the specified data set
> scope"
> What is the problem, why can't I change a dataset based on analysis
> services, i don't have any problems with datasets based on normal
> databases.
>|||Thanx for you're help, it works fine for me!
Ralph Watermann schreef:
> In Short:
> WORKAROUND: If you have created your report using the Report Wizard to start
> the MDX Query Builder, open the .rdl file as XML. Find the section starting
> with <rd:MdxQuery> and ending with </rd:MdxQuery> and delete all spaces and
> newlines between elements (between closing > and opening <) so the whole
> complex element is inline. You will be able to continue working with the
> report normally.
> 1) The problem arises when you use the Report Wizard (as GaryV indicated
> before me)
> 2) If you compare the XML generated by the Query Builder when using the
> Report Wizard and Add existing item... you will see
> a) the complex element <rd:MdxQuery> from the Wizard path is nicely
> formatted with spaces and newlines while
> b) the Query Builder used directly puts the whole long
> <rd:MdxQuery></rd:MdxQuery> "subdocument" inline
> c) the proof is in the pudding - if you delete the formatting characters (I
> ssupect the inlines are key) you can tab to Data and edit the dataset w/o
> problems
>
> See thread " VS crashes when ..."
> "Anke" <anke_ruigrok@.zonnet.nl> schrieb im Newsbeitrag
> news:1134563578.098538.277750@.g49g2000cwa.googlegroups.com...
> > Hi all,
> >
> > I have created a report with the report wizard. I used a cube as a
> > datasource.
> > After creating I also run the report without any problems.
> > However when I go to the data tab to edit my dataset.
> > The dataset becomes empty and my reports is getting errors like
> >
> > "Report item expressions can only refer to fields within the current
> > data set scope or, if inside an aggregate, the specified data set
> > scope"
> >
> > What is the problem, why can't I change a dataset based on analysis
> > services, i don't have any problems with datasets based on normal
> > databases.
> >|||I mean thanx for your help............

Problem deploying 2005 OLAP cube to same server

I have both limited hardware resources and the need to rebuild SQL 2005 OLAP cubes on the same server where they are being accessed. Because of the time needed to rebuild the cube it is preferable not to build it in place but, rather, to build it in another database and then backup/restore to the original location.

There doesn't appear to be a lot of documentation related to operating in this manner. The assumption appears to be that the cube structure will be deployed to another server or a backup is restored to its original location.

That works just fine except that when the underlying data structures (dimensions on which is it built) are changed it 'invalidates' both cubes. All of the objects (cube partitions and dimensions) are MOLAP which I thought made the entire cube structure 'stand alone'. If it is restored to a different physical server this problem does not occur.

Is it in some way considering the dimensions shared? Is there a setting or set of clean-up that needs to be done? Is there a different way to do this other than backup/restore?

Thanks in advance for any help that you could provide.

I am not very clear on what problems you mention you get after restoring the database on the same server under different name.
Try installing SP2 and see if that solves your problem.

Another approach is to install second instance of Analysis Server on the same machine and use it for processing only. This should both save you the hardware and provide level of separation you are trying to achieve.

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

Problem creating view for cube

Anyone see a problem with creating this view for a cube??

The error I get seems to be in line 8 with the sum function, but I see nothing wrong with it.

CREATE VIEW CarCube AS
SELECT CASE WHEN (GROUPING(CarType) = 1) THEN 'ALL'
ELSE ISNULL(CarType, 'Not Known')
END AS CarType,
CASE WHEN (GROUPING(Color) = 1) THEN 'ALL'
ELSE ISNULL(Color, 'Not Known')
END AS Color
SUM(Amount) AS TotalAmt
FROM Inventory
GROUP BY CarType, Color WITH CUBEYou need a comma after Color on the line before|||lol, sometimes the simplest things are the hardest to find.

Thanks|||The people who are really good at finding at simple screw ups are the ones who are really good at making them. ;-)

problem connection Reporting services if change development server

Dear All..

I have develop reporting services 2005 with cube access in Server A.
because any problem in server A. i have copy all solution in server B.
all report in reporting services solution in server B cannot open mdx statement that i have write in RS solution in server A.
If i click data tab in one of report in RS, the mdx script have i write is gone and RS open wizard to make new mdx script again.
How to solve this problem.

any one help me...

thanks

Yudhi
Hai ALL,

I found what problem it is,
the problem is different of SP (service pack). i use service pack 2 in server A and service pack 1 in server B.

thanks all

problem connection Reporting services if change development server

Dear All..

I have develop reporting services 2005 with cube access in Server A.
because any problem in server A. i have copy all solution in server B.
all report in reporting services solution in server B cannot open mdx statement that i have write in RS solution in server A.
If i click data tab in one of report in RS, the mdx script have i write is gone and RS open wizard to make new mdx script again.
How to solve this problem.

any one help me...

thanks

Yudhi
Hai ALL,

I found what problem it is,
the problem is different of SP (service pack). i use service pack 2 in server A and service pack 1 in server B.

thanks all