Search results for query: *

I have an employee dimension where I am applying SCD2. This dimension table has 54 fields. The change any of the attributes needs to be tracked , so a record would be inserted.I have already separated out the fields for which I don't need to maintain history (27 fields) into another table. Now...

I have four different date attributes which describe an employee's certificate/learning activity.I have created a fact table Learning_Fact with associated dimensions. As per data warehousing design principles, time wil be a dimension.In this particular case we have four such dimensions with...

Hello, I have created a hierarchy prompt which allows me to drill down on chosen values and also lets me apply the chosen values at each level to the report. This works fine in Desktop. When I run this report in web, it gives me two lists- one for selection, and one where the selected values...

Is there a way to ask for date + time . It should be a value prompt where the user is able to enter the value rather than select from a list of values from database. I have an attribute based on a DATE datatype column in Oracle. I want the user to enter date-time ranges. Passthrough functions do...

I have created filters A, A-B (nested with A) and A-B-C (nested with A-B) When I use a nested filter, say A - B - C on the report, The user is prompted for A values first. On selecting, he gets the next filtered list of B values and then the final filtered list of C values. On the basis of the...

Features like 'page by' and nested filters are not working in documents. They work fine in web reports thopugh. Is there any way to enable these features in documents?

My reports work fine when run from web. But, on executing a document, I get an old version of the embedded report. Tried options like deleting the document and recreating, restarting IIS, selecting the 'run against warehouse' option on web..but, still this is happening. Any clues as to what...

Is there a away to include an attribute on a report, but, not display it. I want to do this as I need it in the group by of the sql, but, don't want to display it on the report! I need absolute values from fact to be displayed on the report for a,b,c,d versus d I'm doing min(value) for this...

I need a count of records from my fact table based on a condition. I create param_val fact from my fact table F1. One of my dimensions is A1 (based on A1 table having columns Low and High) For each record of the fact table, this param_val needs to be compared to Low and High. I need to count...

I have lookup table having repeating names.I need to create a prompt for choosing names. The prompt comes up with repeating values. Is there a way to display unique or distinct names from this lookup (create dan attribute for this) Please respond. Thanks in advance.

I have a direct project source and a project under it. Now, I want to view the reports in this project on the web. How do I deploy the reports in my project under 'direct' project source on the web? If I modify the project source properties to Server, it does'nt work. Please respond. Thanks in...

I have three fact tables FparamA (with one dimn as paramA), FparamB(with one of the dimns as paramB), FparamC (with one of the dimns as paramC) with numeric columns param_value in each. I need a report where the user would be asked for the parameters (paramA, paramB, paramC) to be displayed and...

I have a report with A1 A2 versus M1 M2. Here, A1, A2 are attributes and M1,M2 metrics. A1 is a numeric attribute. I need a report with a third column C which should be A1 - M1. If I creae a fact f out of this A1 and try using it in C as f-M1, I get an error. How to go about this?

I have a report of dollar sales for products over time. I need to display this in a graphical form. I should be able to take a sales value from the user and for this value draw a straight line on my graph so that the user gets an idea as to which products have how much sales above or below this...

I am trying to implement role-based security in SQLServer 2000 Analysis Services - Cube with database in SQL Server 2000. I have installed Active Directory on Windows 2000. The cube and reports are web-enabled with Excel 2000 pivottable as a client (Office 2000 web components have also been...

I am trying to implement role-based security in SQLServer 2000 Analysis Services - Cube with database in SQL Server 2000. I have installed Active Directory on Windows 2000. The cube and reports are web-enabled with Excel 2000 pivottable as a client (Office 2000 web components have also been...

I have calculated measures which appear when my excel pivottable connects directly to the olap server, but DO NOT appear when I connect to the corresponding .cub file. While creating .cub file (local cube file) , the calculated measures simply disappear. I need help on this ASAP !!!..Please!!!

Can Excel 97 work with a cube file (.cub) of SQL Server 2000 Analysis Services?

How to create a count (calculated measure) in a cube using SQLServer 7.0 OLAP Manager(not SQLServer 2000) For eg. My fact table record is: P_Id, L_Id, T_Id, S_Id, xmeas1, ymeas2 with P, L, T and S as dimensions I need to have count of P as a measure. If I use the usual 'COUNT' function or...

Is there a way to package a project? If I want to move a project from Desktop installed on one machine to another, how should I be doing it? How should I take backup of a project?