Dimension Usage Icons Playing Up

May 29, 2008

Hi,

I was wondering if anyone had come across an issue where the icons in the dimension usage tab of the cube are not being displayed properly, for example if you use a many-to-many the little blue infinity sign is missing. It is a little annoying.

SP2 with BIDS helper, not to sure if BIDS helper did it or SP2, sure it was fine before

Anyone know how to fix it?

Cheers
Matt

View 6 Replies


ADVERTISEMENT

CREATING ROLE-PLAYING DIMENSION

Dec 25, 2007

how to create a role playing dimension in SSAS. Like If I have a period dimension table with a key named as per_key and fact table which has keys named as from_per_key and to_per_key .Now both the fact table keys need to be connected to the Period dimension per_key.

gunja

View 3 Replies View Related

Do We Always Have To Create Name Calculation For Role-playing Dimension?

Jul 10, 2007

Hi, dear friends,

Just found that I am not able to ignore the name column property for role-palying dimension even though I only select one of the key columns for this dimension in the mining structure where the role-playing dimension is used? E.g I have a fact table (which is the case table for the mining structure) which is related to the role-playing date dimension. The schema is as following:

Dim_event_day_time_key

Dim_carrier_day_time_key

Dim_domain_day_time_key

.....................................

and other attibutes in the fact table.

When I dragged the 'hours' attribute from the dim_day_time table to the mining structure, if I left the key columns of 'Hours' as the above 3 columns, then I have to select a name column, by then I dont have a name column in the dimension table yet. Therefore I want to jsut select one key column as the key of that role-playing dimension in the mining structure, but then I am not able to ignore the 'name column' property as it still always asks me to select the 'name column' for that.



Therefore my question is: we are not allowed to select only one key columns in the mining structure for the role-playing dimension? And we will have to always go to the data source view to create a named calculation as the new column for the role-playing dimension?



Hope my question is clear for your advices and I am looking forward to hearing from you shortly.



Thanks a lot in advance.



With best regards,



Yours sincerely,

View 1 Replies View Related

Analysis :: Add Dimension To Cube Dimension Without Any Relation In Dimension Usage

Oct 26, 2015

When i add a dimension to the cube dimension without any relation in my dimension usage to any measure group my units are going down.However when i remove the dimension from the cube am getting the correct values.

View 4 Replies View Related

Analysis :: Role Playing Dimension Among Multiple Fact Tables

Oct 28, 2015

I am modelling cube in SSAS. Cube has around 20 dimensions and 6 fact tables. Some of the dimensions are common among the fact tables. e.g. Time dimension. Fact_PNL has 3 date columns for those we have 3 role playing dimensions in the dimension usages.

Another fact table has 5 date columns for them as well we have separate role playing dimensions in dimension usage tab. We have a common dimension Company which is foreign key in all fact tables. We might need to combine the data from multiple facts to get final output.

Should i create 6 role playing dimension for each of the fact table or use the same dimension for all fact tables?

Role playing dimensions should be created when we have multiple columns pointing to the same dimension ?

View 2 Replies View Related

Slowly Changing Dimension Index Usage

May 22, 2007

We're using slowly changing dimensions to control a number of data tables in our system. Each table has five or six business keys, but the indexes of the tables are built so they're as efficient as possible (i.e. the fields with the highest diversity are listed first). How does the SCD wizard determine the order of the business key fields? Is there a way I can view or manipulate the statement the SCD task is using to make sure either (a) the indexes match the statement, or (b) the statement matches the indexes?

View 1 Replies View Related

Playing About With The AND And OR Conditions

Jul 26, 2007

Hi folks, basically I'm looking for this sort of structure

WHERE (caseA AND caseB) OR (caseC AND caseD) OR (CaseA AND caseD)

but I can't seem to be able to group the AND conditions together any time I try put brackets in SQL Server Enterprise manager removes them on me,

any help would be great,

thanks

View 1 Replies View Related

How Do I Start Playing With Sql Server???

May 20, 2007

Hi all,



please help me!! I've downloaded and installed the express edition file (SQL Server 2005 Express Edition with Advanced Services - 234mb) but all I'm getting on the program menu are the configuration tools! Something appears to be missing - can someone shed any light on this??





THanks in advance

View 3 Replies View Related

Analysis :: Add Descriptions To Attributes In Role Playing Dimensions

Jul 28, 2015

I have a requirement to set Description values for our cube dimensions and attributes. 

I've done this for regular dimensions but I cant seem to find a way for role playing dimensions. I can set the base dimension descriptions but not the 'clones'. Is this possible? 

View 2 Replies View Related

Icons

Aug 17, 2000

i installed sql server 7.0 and when i run Enterprise manager for SQL server (MMC snap in) i see that the SQL server has a little RED SQUIGGLY ACROSS the server icon. can anyone tell me what that means?????
thanks
uday

View 1 Replies View Related

Component Icons

Sep 5, 2007



Hi,
I'm trying to add an icon to a custom component but its not happening and I can't figure out why. I'm sure I've managed to do this in the past. Here's my DtsPipelineComponent attribute:




Code Snippetnamespace Jamiet.Ssis
{
[DtsPipelineComponent(
DisplayName="MyComponent",
Description="Does some stuff",
ComponentType=ComponentType.Transform,
NoEditor=true,
IconResource="MyComponent.ico"
)




MyComponent.ico is stored in the same folder as my project (i.e. at the same level as the .cs file and the C# project file).
In the application property page I've pointed the icon resource at MyComponent.ico

Everything compiles OK. But I see no icon in my component when I deploy it to the toolbox or use it in a package.

I've also tried changing the attribute to this:




Code Snippetnamespace Jamiet.Ssis
{
[DtsPipelineComponent(
DisplayName="MyComponent",
Description="Does some stuff",
ComponentType=ComponentType.Transform,
NoEditor=true,
IconResource="Jamiet.Ssis.MyComponent.ico"
)



Again, it compiles OK, but no icon!

Any ideas what I'm doing wrong?

Thanks
Jamie


View 5 Replies View Related

Icons In Enterprise Manager 7

Jul 20, 2005

Hello,apologizing in advance 4 propably asking a trivial question ...in my Server list in Enterprise Manager 7.0 in front of the name of myservers i have a small server symbol followed by an even smaller greentriangle in a circle (which, according 2 my information means "Serverrunning, currently not connected) followed by a vertical red zigzagline.But the context menue only gives me the optio "disconnect" whichindicates that im "connected"Here my question:what exactly is this symbol trying 2 tell me?1ce again apologies

View 1 Replies View Related

Displaying Windows Icons

Apr 17, 2007

Sir/Mam

I am creating a task manager functionality in c#.net 2003. I am checking only for open microsoft applications . If any microsoft application is opened ,it will display the application name for ex "Microsoft Word" in the listview control and its status "Running" . Now, I want to display the icon for Microsoft word or any other microsoft application, how should I display it in the ListView control.?

I have tried by taking it in the imagelist , because I have a class which returns the Windows Icons for these applications which are opened. But, I am unable to display it.

Please help me???


Thanks,
Shivanee.

View 1 Replies View Related

System Requirements And Icons

Dec 15, 2006

Hi all. First, please accept my apologies for any obvious questions, as im very new to this!Anyway, 2 small questions:
I dont have the 'server running' icon in the system tray... The little grey box with a green arrow. have i installed SQL incorrectly?
This leads my to my other question:- After installation (which, i think went fine), i learnt that SQL Server Express cannot run with more than 1 CPU. But i have a Duel-Core. Would this cause problems?

Again, sorry if if missed any previous posts on this.

Thanks
Adrian.

View 1 Replies View Related

What Do New Icons For Process Locks Mean?

Jan 31, 2008

SQL 2000 is easy to see what process is blocking and what processes are locked. I find 2005 confusing and can't find any documentation on what the new icons mean and or details on interpreting the object/process lock screens.

Thanks, Cindy

View 6 Replies View Related

Ever See This? No Borders Or Icons On Tasks

Oct 3, 2007

I'm setting up a new computer, and opening an SSIS project I've worked on elsewhere. Here's what I'm seeing (see http://tkfiles.storage.live.com/y1pX-TdM6iRI3cSQsl2V4GLd5RAuX2ygIeBbMSb-VM7vTauMSqehrm7pFvpA6N2sFLQFrb4a-1iXnk):



The borders and icons come back if I resize the window by dragging an edge of the window. They disappear again if I maximize the window.

It's very odd, but I'm wondering if it means that something sinister is going on. I didn't set up all of the software on this machine, so I don't fully trust that it was set up correctly.

View 4 Replies View Related

SQL 2012 :: Execution Plan Icons

Apr 8, 2014

I want to find out more information about the execution plan. I saw Parallelism (Gather Streams) in the excution plan. In what situation we can see this icon?If in case if we need to avoid how can we avoid this?

View 5 Replies View Related

Program Icons In Start Menu

Sep 16, 2006

Hello,

I´ve made a mistake on my part. I have deleted my complete program icons for "Microsoft SQL Server" in my start menu.

Is there a simple way to just renew all the icons in my start menu without reinstalling the complete sql server.

Thank you very much for any tips.

View 1 Replies View Related

Icons For Custom Tasks Won't Show Up.

Jul 31, 2006

All aspects of my custom task work well except for the icon!

I have included the .ico in the assembly as an "Embedded Resource" and the icon has both 16X16 and 32X32 images. I have edited the IconResource property of the DtsTask attribute as follows:

IconResource="MyNamespace.MyDLLName.MyIconName.ico",


Where the output assembly is called "MyNamespace.MyDLLName.dll".

Has anybody got this working before? The Icon just never shows (I get the default blue square task icon).

Thanks in advance.

View 7 Replies View Related

Computing The CPU Usage ,memory Usage For An Inserted Record

Nov 2, 2007




I have a client program that writes to sql server database 10 records per second . i want to compute the CPU usage and the memory usage for the whole program or CPU usage,memory usage for the insert statement in the program .

Can anybody help me with this?


View 6 Replies View Related

CPU Usage(%), Logical IO Performed (%) Usage For Adhoc Queries Is 90%

Sep 7, 2007



Hello, When I am seeing SQL Server 2005 Management studio Server Dashboard> I am seeing my(USERS) databases and msdb database usage is very small % of in CPU Usage(%), Logical IO Performed (%) Usage pie chart.

90% of Total cpu usage is showing for Adhoc Queries. what excatly this means in Dashboard? if application uses more than it would have shown in Database level or not?

sicerely this dashboard is good, if any one is watching daily, please advice their experiences here.

Thanks in advance. Hail SQL Server!

View 3 Replies View Related

Any Documentation On SQL Server State Icons Shown In MMC Console?

Feb 8, 2000

Does anyone know of any place I can find documentation on the meanings of the SQL Server state icons displayed in the MMC console for SQL Server 7.0? My server is showing the green running icon but also a vertical red squiggly line. I do not know what this red squiggly line means, and it concerns me. The databases all seem fine, and everything seems to be working, i just have this feeling like something bad is impending and I cannot find anything that tells me what it might be. Any help or suggestions would be greatly appreciated.

View 2 Replies View Related

SQL Server 2012 :: Query To Get CPU Usage / Memory Usage Details Of Server?

Jan 30, 2014

providing a query for fetching the data for CPU Usage, Memory usage, blocking and all details ...

I want to create a job which will run on a Node every 15 min and store data in a table for each instance...

DMV is not giving more stuff and xtended events not sure if i can store that data into a table?

View 7 Replies View Related

Filtering Out 1 Time Dimension Based On The Selection In Another Time Dimension

May 19, 2008

Hi!

Need some help building a query that does the following :

I have 2 Time Dimensions ; Time (Transdate) and ClosedDate (ClosedDate)

In my report/query, if [Time].CurrentMember = [Time].[YMD].[YMD].[2006].[200610].[20061031] I want to FILTER out all ClosedDate < [ClosedDate].[YMD].[YMD].[2006].[200610].[20061031]

Both Time Dimensions are Year -> Month -> Day and have the same Members.

I have every option available, using calculated Members and/or Measures to do this.

The report I'm creating is Aging of Receivables : Balance / 30 days / 60 days / etc.. But for the Aging, I need to filter like explained above.

Appreciate all help!

Regards,
Stian Bakke

View 3 Replies View Related

Dimension

Apr 13, 2005

I ask the question again more clear!

I need to have the same calculeted member for diferentes dimensions.. can i do one calculated member only, that include the diferent dimensions.

Thanks
Paul

View 2 Replies View Related

Third Dimension, Or Something Instead?

Jan 29, 2008

I have table with many rows, and I want to change the structure of base. It is possible to create 3-dimensions table?

View 14 Replies View Related

BCP Usage ???

May 9, 2001

hi there,

i need to transfer the data off a query output to a txt file in the same order as it prints. i have tried using the command
eg.

exec bcp "SELECT au_fname, au_lname FROM pubs..authors ORDER BY au_lname" queryout Authors.txt -c -Sservername -Usa -Ppassword

this is exactly what i used replacing the appropriate parameters, but it gave me a "syntax error near queryout"

PLEASE advice what is wrong or sugest the best method to achieve the same.

Any help would be appretiated.

Thanks,
c: )

View 2 Replies View Related

Max SQL 7.0 Usage

Feb 15, 2000

I need to provide some infomation on how much (trans/request)SQL7 can handle.
I checked the white papers and testimonials, but don't see any actual numbers.
We have a clustered SQL7 environment sitting on some Compaq 6400 using 4 cpu's. Our database size is only about 3.5 gig and we are using IIS 3. Does anyone know where to get this information?

Please advise
Thanks
Susan

View 2 Replies View Related

CPU Usage Is 100 %

Jun 6, 2003

Hi,

We have a SQL Server 2000 Enterprise Edition running as production

The CPU Usage is High when there were >350 user connections.

The buffer hit ratio is good. I checked all the monitor.

Can anyone can guide me why it is causing.

Thanks in advance,
Anu

View 8 Replies View Related

Sql 100% Cpu Usage

Dec 1, 2004

Hi guys, I have a sell server its a new server 4 processors and 4 gigs of ram. SQL server is pinning the CPU's 100% I can’t figure out why, I'm at mdac 2.7 with the hotfix. I don’t know what else to look at.

Any ideas?

View 1 Replies View Related

BCP Usage

Apr 20, 1999

Hi .... I'd like to know if I can use BCP to transfer the whole database to a device or file and then back to the server(I mean,using only one server) with a new char set/sort order configuration,or I have to do it table by table??? How do I use BCP to perform this task?What commands and parameters should I use???

Thanks for your attention,
Luciano

View 1 Replies View Related

Cpu Usage 100% On 6.5 Sql

Sep 15, 2004

we have CPU Usage upto almost 100% i increased the tempdb, and master to almost double the size

then we increased the memory to high amount.


does anyone have suggestion pls help since it running too slow, since we did an upgrade

View 8 Replies View Related

SQL 100% Usage.

Apr 22, 2004

I have a SQL 2000 Server, dual processer with hyperthreading. 2Gb of Ram. The machine is only being used as a SQL Server

Normally the server runs at about 15-20% usage. I have now noticed a problem where the SQL server suddenly jumps to 100%, this can happen after a week or a couple of days. It requires a server reboot to fix the problem. Stopping the SQL server and restarting will not work.

I don't know if this is part of the problem, but I have noticed that after a day or so the processor usage climbs by about 10%, if I stop the SQL service and restart, the processor usage drop by the 10%.

Also I have set the memory usage to be 1.5Gb, but it takes a day or two for the SQL server to consume this amount of memory. Don't know if this has anything to do with it.

Anyone know why this is happening ?

Kev

View 5 Replies View Related







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